Problem on formatting cells

M

mummrra

Hi there!

My excel doesn't change the format of the text inside it:
the dates changed to numbers. I tried to change the format
again by right-clicking the cell and choosing "Formnat
Cell".. however when i try to choose "Date" and indicate
a new type, nothing happens.

This incident happened to my friend too.

please help and thanks in advance
 
F

Frank Kabel

Hi
are you sure the date is stored as date/number and not as 'Text'.<What
does the formula
=ISNUMBER(A1)
return (if A1 is one of your cells). It should return TRUE
 
D

Debra Dalgleish

You may have formulas showing. To turn this off, choose Tools>Options.
On the View tab, under 'Window options', remove the check mark from
'Formulas'
Click OK
 
Top