Date format 01/00/00

G

Guest

When I type in 06/25/07 in one cell, it comes out right, when I type it into
a different cell, it comes out 01/00/00. They are both formatted as dates,
but in the latter cell, the sample reads 01/00/00. What is wrong?
 
D

Dave Peterson

You have a response at your earlier post.
When I type in 06/25/07 in one cell, it comes out right, when I type it into
a different cell, it comes out 01/00/00. They are both formatted as dates,
but in the latter cell, the sample reads 01/00/00. What is wrong?
Click to expand...
 

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

Date formats 1
01/00/00 appearing before date entered 1
Date showing incorrect. 30:00 hrs showing 06:00 4
00/01/1900 1
Please help! date showing as 1900/01/00 2
formatting 6
Format displays 1
Date shows "00:00.0" rather than actual value 6

Top