Dates appear as serial - can't format

  • Thread starter Thread starter mgrairy
  • Start date Start date
M

mgrairy

I have an excel sheet with a bug it seems

all dates are displayed as serial numbers even if the formating says
date and so on... Even when i try to change the formatting nothing
happens.

Any clues?

thx!

sorry about the last post, hit the wrong button
 
You're in "Formula View" mode!

<Tools> <Options> <View> tab,
And *UNSELECT*
"Formulas" under Window Options.

There's also a key combo to toggle this off and on.

<Ctrl> < ` >
which on my keyboard is the same key as < ~ >.
 
Back
Top