Format to Round to Tens Digit

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

Guest

I want to format the numbers to round from 1,536 to 1540. I can only find how
to round multiples of a thousand with the custom formats and I am wondering
if there is a way to do this.

Thanks
 
No, I would like to copy and paste values into a cell and have them display
rounded off to the tenths digit.
 
Tue, 29 May 2007 12:20:01 -0700 from Andy
I want to format the numbers to round from 1,536 to 1540. I can only find how
to round multiples of a thousand with the custom formats and I am wondering
if there is a way to do this.
Click to expand...

Look up the ROUND function.
=ROUND(..., -1)
 

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

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
12 digit number rounding down why? 5
Rounding to thousands in excel 5
Rounds the large numeric value 2
Round up or down by set variable 3
Round formula 1
rounding 6
format to round down 2

Back
Top