G Guest Feb 13, 2006 #1 How can I display 123,432,000 as 123,400 using custom formats? What I need is rounding to the nearest 100,000.
How can I display 123,432,000 as 123,400 using custom formats? What I need is rounding to the nearest 100,000.
G Guest Feb 14, 2006 #3 Yeah, tried that but it gives me 123,432 rather than the 123,400 that I'm after. Any other ideas? Thanks, Ray.
Yeah, tried that but it gives me 123,432 rather than the 123,400 that I'm after. Any other ideas? Thanks, Ray.
R Ron Rosenfeld Feb 14, 2006 #4 How can I display 123,432,000 as 123,400 using custom formats? What I need is rounding to the nearest 100,000. Click to expand... 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
How can I display 123,432,000 as 123,400 using custom formats? What I need is rounding to the nearest 100,000. Click to expand... 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
P Philip Reece-Heal Feb 14, 2006 #5 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
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
