Data entry error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin W (W_at_discussions.microsoft.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 10:55:01 -0800

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.

Quantcast