Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to millions
I want to round numbers to millions, with one decimal point, and negative
numbers in black in parentheses. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to millions
##0.0,,;[Black](0.0,,)
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ken W" wrote in message ... I want to round numbers to millions, with one decimal point, and negative numbers in black in parentheses. How do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to millions
Hi Ken
Rounding Numbers to Millions To round a numbers to millions: 1. Press Ctrl+1 to open the Format Cells dialog box. 2. Select the Number tab, and from Category, select Custom. 3. In the Type box, enter the following Custom Formatting syntax: #,##0,, ;[Red](#,##0,,);- ; Result: €¢ Original number: 5,645,625 €¢ The displaying formatted number: 6 Note: The number formatting syntax is: Positive; Negative; 0; Text "Ken W" wrote: I want to round numbers to millions, with one decimal point, and negative numbers in black in parentheses. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding data entered as Millions, how to please | Excel Worksheet Functions | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |