Cannot set cell format

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Any number entry in a cell on a new workbook has incorrect
default setting. If I input 400, it displays 4. If I
enter 4, it displays as 0.04. Something has happened to
the 'default' setting, but I see no way to set
a 'default', as you have in word for the normal.dot.

If I open existing spreadsheet, numbers show correct, but
new entries are incorrect.
I need numbers to be general for purposes of this
spreadsheet.

Any help would be greatly appreciated.
Thank you,
Glenn
 
Thanks Andy!!
BINGO!

It is people like you that restore my faith in humanity.
The user in question swore that they made no changes to
the settings, and I did not make the connection while
looking through options.

Thank you very kindly.

Glenn
 
Andy???


glenn said:
Thanks Andy!!
BINGO!

It is people like you that restore my faith in humanity.
The user in question swore that they made no changes to
the settings, and I did not make the connection while
looking through options.

Thank you very kindly.

Glenn
Click to expand...
 
Thank you Paul, that did the trick. Read my previous
email, where I thank Andy. He emailed me directly, but my
thanks in that message apply to you as well.

Glenn
 
Back
Top