+ Reply to Thread
Results 1 to 2 of 2

Data entry error

  1. #1
    Kevin W
    Guest

    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.

  2. #2
    JE McGimpsey
    Guest

    Re: Data entry error

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1