Re: Data entry error

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 01/07/05 

Date: Fri, 07 Jan 2005 12:48:57 -0700

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.