01/00/00 appearing before date entered

J

JStiehl

I am entering a date (1-23-10) in a cell (N8) and copying the cell contents
to another cell (Q8). When the date appears in Q8, it puts 01/00/00 before
the date I entered, so I get something that looks like 01/00/001-23-10. I
have seen many posts on how to eliminate this if the cell is blank, but the
cell is not blank. Any ideas? Thanks so much for your help.
 
E

Eduardo

Hi,
check the format of the cell, I guess you have custom format applied to that
cell
 

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

Similar Threads

Please help! date showing as 1900/01/00 2
Date format 01/00/00 1
How to enter start and end date/time in excel based on some specific value. 7
Date shows "00:00.0" rather than actual value 6
Cell showing date and time - precision error 2
Date changes to 0-Jan-00 when I leave cell 10
Date Time formatting problem 7
Date shows as 01/01/00 2

Top