Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    fixed decimal (XP)

    Is there an easy work-around to force Excel to show a zero on the end of a number when using the fixed decimal feature? For example, I set the default to 2 decimals and type 5230 in a cell - the result after "enter" is 52.3 . . .

    Thanks again
    Aunt Linda

    PS - also doesn't seem to work to "fix" the decimals if you fill numbers in a series or the result of a formula - the decimals are all over the place based on the result of the formula or the series fill. What am I missing?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: fixed decimal (XP)

    The fixed decimal feature you're talking about has to do with data entry, not with the way data are displayed. You should set that separately:

    Select the cells.
    Select Format | Cells...
    Activate the Number tab (if necessary)
    Select Number in the list of categories.
    Specify yhe number of decimal places you want to display.
    Click OK.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: fixed decimal (XP)

    Aunt Linda

    Format your cells to the custom format of #.#0
    Jerry

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fixed decimal (XP)

    Hey Hans - as usual, you've shown me as the non-thinker I am . . . duh and duh again.

    But thank you for your patience . . .

    Aunt Linda

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fixed decimal (XP)

    Thanks, Jerry.

    BTW - absolutely love . . .

    Antiquis temporibus, nati tibi similes in rupibus ventosissimis exponebantur ad necem

    Confess I went to a latin phrase site - since this is from one of my all-time favorite movies, had to include it in this post . . .

    Mater tua criceta fuit, et pater tuo redoluit bacarum sambucus

    Aunt Linda

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: fixed decimal (XP)

    Post deleted by Jezza
    Jerry

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: fixed decimal (XP)

    Jerry,

    I don't understand your 'small point'. Setting Format to Number with 2 decimal places is equivalent to a custom format <code>0.00</code>. That is not much different from <code>#.#0</code> except that you'll get <code>0.45</code> instead of <code>.45</code>.

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fixed decimal (XP)

    I did go to Jeeza for the translation of YOUR Latin - got what I sent you from the latin phrase site.

    You are correct, of course, about the 0 -

Posting Permissions

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