Custom format rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Formatting 7
Rounding Time to Nearest 5 Minutes 1
rounding figures to nearest thousand 3
Round Question 3
rounding up to the nearest 1000 1
Alternate Rounding Up & Down of .50 in a column 5
Round Function 5
Rounding time values up and down 2

Back
Top