Format Date

R

rah44

I am trying to format a date in a cell. The date within the cell reads
9/10/07, but 39335 is displayed on-screen. I know the standard procedure on
how to change the format of a cell to date/ number etc., but there is
definitely something wrong here. I have tried formatting the cells to
different things, but the cell continues to read this same data stream.
 
R

rah44

Never Mind! Somehow, I had hit a shortcut key that displayed all formulas.
I turned this off in tools/options and the dates displayed fine.
 
G

Gord Dibben

Could be you are in "Formula View".

Hit CTRL + `(backquote above Tab key) to toggle out of formula view.


Gord Dibben MS Excel MVP
 
Top