+ Reply to Thread
Results 1 to 4 of 4

decimal formatting

  1. #1
    Registered User
    Join Date
    02-28-2007
    Posts
    2

    Question decimal formatting

    Hello folks,

    I have a problem that's driving me up the wall and was hoping someone on here would be able to provide me with a quick fix.

    When I type a number into a cell, and hit return the number comes up as a decimal. For example, if I type 25, the number is displayed as 0.25. Or if I type 1254, the number is displayed as 12.54. or 10987 is displayed as 109.87, etc.

    It seems that I have changed a default setting (or some such) to display the number as 1/100th of its original value!!! I have tried playing with the formatting, but to no avail.

    Any help on this would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Go to tools>options>edit

    then click the box that says "fixed decimal" so there is NOT a check mark in that box

  3. #3
    Registered User
    Join Date
    02-28-2007
    Posts
    2
    Excellent,

    Thank you BigBas

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    No problem. Glad it worked.

+ 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