Thread: EXCEL
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default EXCEL

ToolsOptionsEdit, uncheck Fixed decimal

--
Kind regards,

Niek Otten

"BIBBYBIBBER" wrote in message
oups.com...
excel
BIBBYBIBBER - Nov 18, 9:41 am
When I enter a number in a newly opened fresh spreadsheet the number is
automatically divided by 10.0. When I enter a number below 1.0 this
effect does not occur. I have used Excel for over 8 years and never
have experienced this phenomenon, it is driving me crazy. Can someone
please tell me what is going on and how to fix it?