Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting in 1000's
I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I
divide each cell by 1000 to get the results I want (=5,000,000.00/1000=5,000) and format to zero decimals. Thanks |
#2
|
|||
|
|||
You could create a Custom Format : #,##0,_);(#,##0,)
FormatCellsNumber tab Under Category, select Custom and enter: #,##0,_);(#,##0,) in the type box. NOTE: doing that won't change the actual value of the number, so 5,000,000 will still be 5 million, but it'll look like this: 5,000 Does that help? Regards, Ron "William Copeland" wrote: I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I divide each cell by 1000 to get the results I want (=5,000,000.00/1000=5,000) and format to zero decimals. Thanks |
#3
|
|||
|
|||
You can just add a comma to each of the arguments in any of the number
formats, and it will reduce the visual value by a factor of 1,000. Two commas will reduce by 1,000,000 and so on. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "William Copeland" wrote in message ... I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I divide each cell by 1000 to get the results I want (=5,000,000.00/1000=5,000) and format to zero decimals. Thanks |
#4
|
|||
|
|||
Yes, this works perfectly and it was so easy. Thanks.
"William Copeland" wrote in message ... I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I divide each cell by 1000 to get the results I want (=5,000,000.00/1000=5,000) and format to zero decimals. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting 100's and 1000's | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |