Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Location
    london
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Formatting (97)

    Sorry if this is a particularly low level question, but I've spent far too long trying to work it out, so please, please help!
    How do you change the true value of a cell to 2 decimal places? I know how to format cells so they appear to be to 2 decimal places but cannot change their true value.
    Thanks
    Katharine

  2. #2
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Formatting (97)

    Try ROUND(A1,2) - There are other versions of ROUND, ROUNDUP, ROUNDDOWN.... Use whichever works..

    Regards
    Peter

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

    Re: Cell Formatting (97)

    A rather drastic measure is to select "Precision as displayed" in the Calculation tab of Tools | Options...
    If you check this option, ALL values will be stored with the number of decimals displayed on-screen.

    You can also use formulas: in your example, enter =ROUND(A2,2) in cell B2. Then double click the fill grip (the little black square in the lower right corner) of B2 to fill down the formula.

    If you want to replace the original values: with the block still selected (B2:B14 in your worksheet), select Edit | Copy, then Edit | Paste Special..., Values, OK. Then drag the block over to column A and confirm that you want to overwrite the existing values. Note that this will destroy any formulas you had in the original cells.

Posting Permissions

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