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.