Apply Round Formula via VBA to 12 columns containing both formulas and values

[CCantara]

Hi Folks,

I've had great luck with the members of this site, so here goes...

I have a data sheet where 12 columns contain a dynamic number of rows/cells where some are formulas and some are hardcoded values. This file is submitted each month. I would like a macro to insert the "Round" function to 2 decimal places into all the cells in these 12 columns only.

Specifically, the macro would:
1) add "=round(value,2)" to cells without formulas and greater than 0, and not "",
2) skip cells where there is already a round function included, and
3) add "round(formula,2)" to cells with other formulas.

If there's any chance someone could help me with this, I would be most appreciative.

Thanks.

CCantara

 

[mole999]

question would be , why do you need to round, you can apply a format to two decimals without having to touch anything

 

[CCantara]

question would be , why do you need to round, you can apply a format to two decimals without having to touch anything

This worksheet is used to upload data into an SQL Database. Data comes in from many sources, some manipulated by formulas, some not. SQL will not recognize the cell formats, only the underlying data. It must be stripped first.

Thanks for your time, though!

 

[mole999]

in that case
Excel TRUNC Function - Reduce Decimals Places without Rounding