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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com