VBA code to remove everything after the decimal point

Hi,
I want a vba code that will remove everything after the decimal pooint in the entire workbook,without rounding the numbers.
then remove all the formulas throughout the entire workbook that is present there.
thanks for help.

Hi Fatalcore,

I suggest you remove the formulas first, since some of them may result in decimal numbers. The code below removes all formulas and then converts all numbers to integers (does not round). It loops through every worksheet in the workbook, too.

Please Login or Register  to view this content.

Try this slight change in Paul's code

Please Login or Register  to view this content.

It worked for me.

Good catch, Mordy. (Do you mind if I call you Mordy?)

Originally Posted by Paul

Good catch, Mordy. (Do you mind if I call you Mordy?)

Just don't call me Shirly!

alternative:

Please Login or Register  to view this content.