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

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 do I change a number into a date format in Excel? Microsoft Excel has a feature that allows you to convert a number into a date, which is quite simple to do.

How to Change to Accounting Format in Excel. The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number.