+ Reply to Thread
Results 1 to 2 of 2

Removing a FIXED Function

Hybrid View

  1. #1
    Amy Sandlin
    Guest

    Removing a FIXED Function

    I need to know how remove a FIX function. At the bottom right corner of my
    worksheet, the word FIX is present. Everything that is enetered is rounded
    off. For exmple, if I key the following # 123 it then reads 1.23 with 2
    decimal places. If I key the same # with the formatting reading no decimal
    places, then 123 entered rounds to 1. I the same sense, if I key in a 2
    digit # like 12 the upon entering the # appears as .12 with 2 decimal places.
    If it is formatted to no decimal places then it rounds to 0 (zero).



  2. #2
    Peo Sjoblom
    Guest

    Re: Removing a FIXED Function

    Tools>options>edit and uncheck fixed decimal places

    Regards,

    Peo Sjoblom

    "Amy Sandlin" <Amy Sandlin@discussions.microsoft.com> wrote in message
    news:8EDDFF67-8C11-4C51-9656-15000CFB7954@microsoft.com...
    > I need to know how remove a FIX function. At the bottom right corner of

    my
    > worksheet, the word FIX is present. Everything that is enetered is

    rounded
    > off. For exmple, if I key the following # 123 it then reads 1.23 with 2
    > decimal places. If I key the same # with the formatting reading no

    decimal
    > places, then 123 entered rounds to 1. I the same sense, if I key in a 2
    > digit # like 12 the upon entering the # appears as .12 with 2 decimal

    places.
    > If it is formatted to no decimal places then it rounds to 0 (zero).
    >
    >




+ 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