Tuesday, April 10, 2012

Excel shows numbers instead of a date

This is frequently due to the formatting of a cell. Highlight the cell(s) you are having trouble with, and check the cell format by clicking on the “home” tab:

image

Then look in the “Number” section. You’ll see the format listed there. In this example, it’s set for “general”.

image

Change it to be “date” and it should work how you are expecting it to.

No comments:

Post a Comment