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

On Wed, 1 Feb 2006 23:26:28 -0800, "malcolmt"
<malcolmt@discussions.microsoft.com> 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

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"
> <malcolmt@discussions.microsoft.com> 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
>