Round

[matrixknow]

Hi,

With the function Round() it is easy to round some numbers.

Please Login or Register  to view this content.

I was wondering how to round some numbers in a column with my code.
The numbers should stay numbers without decimals. Do I need a Range or a Loop to applicate the round Function on the doubles of my column. Or a Format or Replace ?

Can the content of a cell easily replace itself ?

[boylejob]

matrixknow,

You could try something like this.

Please Login or Register  to view this content.

I am assuming that the commas in the number examples you posted were suppose to be periods.