I have formatted cells to date but when I enter in a date of 020413 (Feb 04, 2013) my reslut shows as 11/20/55. I have a coworker who is having the same problem (but hers displays even a different date) so was wondering if there is a setting in excel that I don't know about.
Thanks!
Excel deals with dates as numbers. The number for today's date is 41400. The number for 20th November 1955 is 20413. So when you type in the date with no separators (i.e. 02/04/13) Excel shows the date it thinks you mean.
If I've been of help, please hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks