Date formats

  • Thread starter Thread starter thelenew
  • Start date Start date
T

thelenew

I have a sheet, that I format the cell for a date EX: 12/01/03

But it returns the date 10/29/28? What's wrong here?
 
thelenew said:
I have a sheet, that I format the cell for a date EX: 12/01/03

But it returns the date 10/29/28? What's wrong here?
Click to expand...

You typed in 120103. You should have included the / characters: 12/01/03.
Formatting the cell as date does not affect the way you input data. It only
affects the way that data is displayed.
 
Is there a format to use that would let you enter "just numbers?"
 
You must log in or register to reply here.

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 issues 1
Specific Date from a Range 3
This should be easy - date lookup 9
Week Number Format 4
Conditional Formatting - Dates 2
TODAY formula 2
Formating Dates 4
Sort problem - help! 3

Back
Top