date problem

  • Thread starter Thread starter evilyn
  • Start date Start date
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
 
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
Click to expand...

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