Trying to use an Excel Date and Time function, but Excel returns a serial number instead of date; this is because Excel stores dates and times in serial numbers in the backend; for instance, when ...

Click on the date/time cell. Go to Format > Number. Select the Custom date and time option. Select a date/time format. Click the Apply button. To learn more about these steps, continue reading.

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

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.