date format frustration!

[Guest]

I'm having no luck! When I enter 07/29/2004 it comes out 36735. I've tried
the format option but no luck...what am I missing?

Thanks in advance!

 

[Frank Kabel]

Hi
formating this cell as 'Date' should do

 

[Gord Dibben]

Check your Date settings at Tools>OptionsCalculations.

Uncheck the 1904 date system.

Your dates are off by 1462 days.

36735 is July 28, 2000

Gord Dibben Excel MVP

 

[Guest]

Tried that...still no luck

Hi
formating this cell as 'Date' should do

 

[Frank Kabel]

Hi
what is shown in the cell and what format did you choose?

 

[Dave Peterson]

Maybe...

Tools|options|view tab
uncheck formulas