Looping through the same task

[Neeve]

Edit: Looping*

Hi everyone,

I am using a macro to convert decimal numbers to a value with only two decimals.
The macro I use is as follows:

Please Login or Register  to view this content.

The only problem is that when I make a large selection of cells (to the right of them), this macro will only work for the first one
I have hundrends and thousands of such numbers.

How do I make it convert them all?

Ideally, if I could have just 1 button that converts every number on the sheet anywhere (such as 643.52652526) into exactly 643.53 (not just display rounding) that would be amazing. The sheet will also have strings that should not be converted, so that makes it more tricky (eg. some kind of IF statement on every single cell perhaps with a limit of 2000x2000 that if it's a decimal, convert it as above).
But for now, just selecting and having the macro run through every number would be much better than what I currently have.

Thanks!

[HaHoBe]

Hi, Neeve,

maybe try this code on a copy of your worksheet:

Please Login or Register  to view this content.

Ciao,
Holger

[Neeve]

Hi, Neeve,

maybe try this code on a copy of your worksheet:

Please Login or Register  to view this content.

Ciao,
Holger

This is amazing and does everything that I wanted, very elegant script!
Thank you!

[JBeaucaire]

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.