Do you mean you want a macro that will be run one time and which will
permanently change your formulas so that they include the ROUND function
afterwards? If so, do **ALL** your formulas return numeric values (or do you
have some that perhaps return dates, text, etc.)? If not, are the formulas
that do return values confined to the same column or columns so they can be
selected or their range(s) specified?

--
Rick (MVP - Excel)


"Steph" wrote in message
...
I have a large data set that includes text, constants, and formulas. I
would
like to add the ROUND function to each cell where a formula occurs (i.e.
round the value returned from each formula to zero decimal points). Can
anyone suggest a macro to do so?

Thank you.

--
Steph