Rounding columns

Originally Posted by sandy666

maybe use Get&Transform

Sorry, Have no idea what Get&Transform is.

basically I have columns of figures in a spreadsheet and wish to changer all the number in each column to the nearest 10 i.e.


123 to 120
346 to 350
10,707 to 10,710
3 to 0
etc

I'm sure there must be some simple way to format the cells to do that, but I can find that in Excel Help or on Google.