Thread: 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.

Tools/Options/Edit uncheck the Fixed Decimals checkbox

In article <DFEE22F3-9992-4BFB-969C-B70BE6FE5E8B@microsoft.com>,
"Kevin W" <Kevin W@discussions.microsoft.com> 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.