ExcelBanter - Data entry error

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data entry error (https://www.excelbanter.com/excel-worksheet-functions/8856-data-entry-error.html)

Kevin W

Data entry error

When entering numbers, excel divides the entry by 10, so that by typing in
"220000", the cell contents become "22000". Reformatting the cell then has
no effect on the contents of the cell, changing it to "22,000" for example.
The error does not occur if you type either a comma separator or a decimal at
the end of the numerical entry. Is there any known fix for this? Thanks for
any help.

JE McGimpsey

Tools/Options/Edit uncheck the Fixed Decimals checkbox

In article ,
"Kevin W" <Kevin wrote:

When entering numbers, excel divides the entry by 10, so that by typing in
"220000", the cell contents become "22000". Reformatting the cell then has
no effect on the contents of the cell, changing it to "22,000" for example.
The error does not occur if you type either a comma separator or a decimal at
the end of the numerical entry. Is there any known fix for this? Thanks for
any help.

All times are GMT +1. The time now is 07:47 AM.