Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
How to format text and numbers as custom | Excel Discussion (Misc queries) | |||
How do I make custom formats with superscript or subscript%3f | Excel Worksheet Functions | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Worksheet Functions |