Custom format rounding
 

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

Custom format rounding
 

#,###, 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.

Custom format rounding
 

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.

Custom format rounding
 

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

Custom format rounding
 

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.