1. ## 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. ## Re: Cell Formatting (97)

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

Regards
Peter

3. ## 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
•