date problem

[evilyn]

this is probably some rookie mistake that i am just not thinking of.
i enter the date 2.19.1979 but it shows as 28905 & i can't make it
show the other way. i have 3 worksheets in the workbook & only 1
shows the dates this way. i tried the obvious format cells option but
it didn't change.

its monday & my brain is not working right, your help is appreciated.
thanks, e

 

[evilyn]

this is probably some rookie mistake that i am just not thinking of.
i enter the date 2.19.1979 but it shows as 28905 & i can't make it
show the other way.  i have 3 worksheets in the workbook & only 1
shows the dates this way.  i tried the obvious format cells option but
it didn't change.

its monday & my brain is not working right, your help is appreciated.
thanks, e

well i fixed it with text to columns & changed it to text.

 

[Dave Peterson]

If you see 28905, then either format the cell as a date (format|cells|number
tab)

or make sure you're looking at dates (not formulas).

Tools|Options|view tab|uncheck Formulas

(Ctrl-` (control-backquote to the left of 1/! on my USA keyboard is the shortcut
key toggle)

I'd change the data back to real dates. It maybe important if you ever need
real dates.