You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

Tables can be really handy when trying to organize information in Excel or Google Sheets, but if you need to get rid of the formatting, here's how to do it.

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...