View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lobster Lobster is offline
external usenet poster
 
Posts: 6
Default 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