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

Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
separating date and time 5
Payment calculation 1
Cell showing date and time - precision error 2
Date format 01/00/00 1
Date shows "00:00.0" rather than actual value 6
add 4 days 9
Date Changes to 01/00/00 when i enter any date. 0

Top