ToolsOptionsEdit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lobster" wrote in message oups.com...
| This has got to be a daft question but I'm damned if I can see what's
| causing it...
|
| If I enter a number like "23" into a cell (ie without the quotes), it
| transates on screen to "0.0023" unless I specifically enter it as
| "23.0".
|
| This is for a cell formatted as "General" "Number" or "Currency", but
| not as "Text". Happens on any spreadsheet on my PC, and has been
| doing
| so for weeks!
|
| What have I done wrong?
|
| Thanks
| David
|