To convert a serial number to a date format, follow the steps below. Select the cell you want to format. On the Home tab in the Number group, click the bottom right arrow.

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 ...

It's easy to change the date format in Microsoft Excel. ... Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes 42797 when it's not formatted as a date.

If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date. Laura McCamy/Business InsiderThe long date option will write out dates for you. 4.

Open the Excel 2010 file that contains the phone numbers you want to change. Click on the cell that contains the phone number, or click on the range of cells if you want to change the format for ...