How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.

#,###, seems to do what you want

Regards
Philip
"Ray88" wrote in message
...
How can I display 123,432,000 as 123,400 using custom formats? What I need
is
rounding to the nearest 100,000.

Yeah, tried that but it gives me 123,432 rather than the 123,400 that I'm
after. Any other ideas?

Thanks, Ray.

"Philip Reece-Heal" wrote:

#,###, seems to do what you want

Regards
Philip
"Ray88" wrote in message
...
How can I display 123,432,000 as 123,400 using custom formats? What I need
is
rounding to the nearest 100,000.

Best I can come up with is by formula in adjoining column; i.e.,
=ROUND(RC[-1],-5) and applying format #,###, to that

Sorry
Philip
"Ray88" wrote in message
...
Yeah, tried that but it gives me 123,432 rather than the 123,400 that I'm
after. Any other ideas?

Thanks, Ray.

"Philip Reece-Heal" wrote:

#,###, seems to do what you want

Regards
Philip
"Ray88" wrote in message
...
How can I display 123,432,000 as 123,400 using custom formats? What I
need
is
rounding to the nearest 100,000.

On Mon, 13 Feb 2006 15:00:12 -0800, "Ray88"
wrote:

How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.

As far as I know, you can only use custom formats to display rounding to the
nearest 10^x where mod(x,3) = 0


--ron