Learn Excel 365 number formatting to create clear, professional spreadsheets. Learn essential tips and advanced techniques for data clarity ...

For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.

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.

Although Google Sheets and Excel Online are two of the best free online spreadsheets editing apps, you may not like certain features of them. For example, the date format. In case you do not want ...