Custom formatting to round to TENS

I need to take a column of numbers and round them to the nearest 10. This is for a worksheet that will go out to clients, and we aren't allowed to leave functions (such as =mround(5556.54645645656, 10)) in place. However, the only alternative is to just type over that long number with "5560", which eats the original number and isn't desirable either.

Therefore, I have come to look at custom formatting. The closest thing I have found is this thread:

http://www.excelforum.com/excel-form...465-000-a.html

But that's to thousands, which doesn't help me.

Any suggestions? Please help!!!

Thanks,

-A.

It's for work - believe me, this is not my idea of fun. -.-'

I thank thee, fellow Texan.

Hi Amanda

I have tried with this custom format ###,"0" but I could get 60.

Thanks
Shyam

---

Originally Posted by L-Drr

can't you just use a formula and then cut all and paste as values?

I can, but that will eat the original numbers.

I ended up doing this:

Please Login or Register  to view this content.

Which isn't as efficient as I was hoping, but it will get the job done.

Thanks for all y'all's help.