Date formats

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?
 
P

Paul

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.
 
Top