Format Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Could be you are in "Formula View".

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


Gord Dibben MS Excel MVP
 
Back
Top