DATE FORMATTED COLUMN ERROR

G

gveames

WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is
showing as 38317
 
N

Norman Jones

Hi Gveames,
WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER?

Excel stores dates as a serial number derived from the number of days
elapsed since the beginning of 1900.

To convert the serial numbers to visual date representations,. try
formatting the relevant cells with a date (or custom) format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top