ExcelBanter - EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/56138-excel.html)

BIBBYBIBBER

EXCEL

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?

Niek Otten

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?

All times are GMT +1. The time now is 12:43 PM.