Excel spreadsheets messing up my decimal point
 

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

Excel spreadsheets messing up my decimal point
 

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
|

Excel spreadsheets messing up my decimal point
 

On 9 Nov, 13:42, "Niek Otten" wrote:
ToolsOptionsEdit tab, uncheck Fixed decimal

Fantastic! Thanks, Niek.

(How on earth did that box ever get ticked? I'm sure I've never even
viewed that particular sub-menu before! And I'm struggling to think
what possible use this decimal facility is...)

David


"Lobster" wrote in ooglegroups.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
|