Custom formats to round numbers such as 465,123 to 465,000
Rather than use the @round function which can be tedious at times I would
like to know if you can use custom formats to complete the task |
Custom formats to round numbers such as 465,123 to 465,000
On Wed, 1 Feb 2006 23:26:28 -0800, "malcolmt"
wrote: Rather than use the @round function which can be tedious at times I would like to know if you can use custom formats to complete the task For your specific example, to display rounded to the nearest 1,000, you could use this custom format: #,",000" You need to be aware that one of the differences between using the ROUND (this is excel, not Lotus -- no @round) worksheet function in Excel is that the number that is stored is actually rounded, and the rounded number will be used in subsequent calculations (465,000 in this instance). With formatting, the number stored is the actual number, and that actual number (465,123 in this instance) is what will be used in subsequent calculations. --ron |
Custom formats to round numbers such as 465,123 to 465,000
thanks Ron,
i converted the custom format to #,"" to remove the zeroes and comma. "Ron Rosenfeld" wrote: On Wed, 1 Feb 2006 23:26:28 -0800, "malcolmt" wrote: Rather than use the @round function which can be tedious at times I would like to know if you can use custom formats to complete the task For your specific example, to display rounded to the nearest 1,000, you could use this custom format: #,",000" You need to be aware that one of the differences between using the ROUND (this is excel, not Lotus -- no @round) worksheet function in Excel is that the number that is stored is actually rounded, and the rounded number will be used in subsequent calculations (465,000 in this instance). With formatting, the number stored is the actual number, and that actual number (465,123 in this instance) is what will be used in subsequent calculations. --ron |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com