Rounding columns

Can you please advise me how to round whole columns of numbers in Excel 365- for example to the nearest 10.

maybe use Get&Transform

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.

see here:

gt.jpg

• PowerQuery (Get&Transform) works with M-language and does not contain any classic formulae or vba code
• What is PowerQuery? see here: Getting Started with PowerQuery (Get&Transform) in Excel