Open Excel Online on your computer. Right-click on the date/time cell. Select the Number Format option. Switch to the Date tab. Select a date format you like. Click the OK button. Let’s check ...

We're using a spreadsheet that includes dates of hire for employees of a fictitious company, to show different ways to format dates in Excel. 1. Highlight the date cells you want to format. 2.

Using specific date and time formats, you can display a date or time in many ways. That’s not how Excel stores a date, though—not as the formatted string that you see.