# Thread: Rounding Figures in Excel (97 SR2)

1. ## Rounding Figures in Excel (97 SR2)

Is there a way of rounding a figure of say 8,445,235 to 8.4 in Excel? I have looked at the round option but it only seems to work with decimal points.

2. ## Re: Rounding Figures in Excel (97 SR2)

format the cell as #.0

The formula =round(A1/1000000,1) should work - assuming your figure is in A1

3. ## Re: Rounding Figures in Excel (97 SR2)

Hi,
You can do that by giving the cell the following custom format:
0.0,,
Hope that helps.

4. ## Re: Rounding Figures in Excel (97 SR2)

Hey, let's all pile on and give different answers! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> This will also work for what you want:
=ROUND(A1,-5)/1000000
if you want billions (or, outside the US, thousands of millions) formatted with a comma, e.g. 1,008.4 for underlying amount of 1,008,445,235.

5. ## Re: Rounding Figures in Excel (97 SR2)

The rest of the world joined you some years ago. A billion is now internationally recognised as 1,000,000,000. The change increased the age of the universe considerably.
For trivia buffs 1,000,000,000 used to be known in Britain as a milliard.

#### Posting Permissions

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