If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Number Formats and system | Josh O. | Worksheet Functions | 3 | August 27th, 2004 01:49 AM |
Alignment in Custom Number Formats | Eric | General Discussion | 1 | August 14th, 2004 12:14 AM |
Custom # formats | Keyur | Worksheet Functions | 1 | February 13th, 2004 02:41 PM |
Saving Custom Formats | Bob Campbell | Worksheet Functions | 1 | November 26th, 2003 03:00 PM |
Apply custom Cell Formats | Randy | Worksheet Functions | 2 | October 14th, 2003 03:46 AM |