Thanks that's great, worked a treat!

"Chip Pearson" wrote:

Try

=ROUNDUP(A1,-1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tilly" wrote in message
...
I have a spreadsheet that gives me the total number of people
passing through
our gates each year for each site, however I need to round up
the numbers to
the nearest mulitple of ten for our brochure numbers, is there
an easy way to
do this or is it a case of putting them in manually/