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

On Nov 3, 1:52*pm, evilyn wrote:
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.

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.

evilyn wrote:

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

--

Dave Peterson