|
| |
Microsoft Excel
Scale Large Numbers by Multiples of One Thousand
Description
Have you ever wanted to drop the ending digits in a
large number without adding a formula to round the number? For
example, shorten the display of 6,112,550 to 6,113.
It's easy to scale a number by multiples of one
thousand by using cell formatting. No formulas are needed.
In Microsoft Excel
Font Dialog Box
-
Click on the Number tab
-
Select the Custom Category
-
In the Type text box, input #,###,
-
The # sign displays only significant digits
-
The comma is the thousands separator.
To scale a number by a multiple of one thousand, include a comma
at the end of the number format. If you want to
scale a number by 100,000 then you would add two commas to the
end of the custom format.
-
Click the OK button to close the Format
Cells dialog box.
Sample Microsoft Excel Worksheet with Scaled Number
|
