software

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
quot;Ray88quot; gt; wrote in message
...
gt; How can I display 123,432,000 as 123,400 using custom formats? What I need
gt; is
gt; 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.

quot;Philip Reece-Healquot; wrote:

gt; #,###, seems to do what you want
gt;
gt; Regards
gt; Philip
gt; quot;Ray88quot; gt; wrote in message
gt; ...
gt; gt; How can I display 123,432,000 as 123,400 using custom formats? What I need
gt; gt; is
gt; gt; rounding to the nearest 100,000.
gt;
gt;
gt;

On Mon, 13 Feb 2006 15:00:12 -0800, quot;Ray88quot; gt;
wrote:

gt;How can I display 123,432,000 as 123,400 using custom formats? What I need is
gt;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

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
quot;Ray88quot; gt; wrote in message
...
gt; Yeah, tried that but it gives me 123,432 rather than the 123,400 that I'm
gt; after. Any other ideas?
gt;
gt; Thanks, Ray.
gt;
gt; quot;Philip Reece-Healquot; wrote:
gt;
gt;gt; #,###, seems to do what you want
gt;gt;
gt;gt; Regards
gt;gt; Philip
gt;gt; quot;Ray88quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; How can I display 123,432,000 as 123,400 using custom formats? What I
gt;gt; gt; need
gt;gt; gt; is
gt;gt; gt; rounding to the nearest 100,000.
gt;gt;
gt;gt;
gt;gt;