Hi Jim,

In my sheet All formulas are strictly =Sum()
Is there a MACRO (VBA) that can CHANGE All = Sum()'s formulas
to =Round(Sum(),0) at once ?

If so, could someone share code.
I've been trying now for an hour, but without success
including a google search.

Check this page:

http://www.jkp-ads.com/Articles/FormulaWrapper00.htm

Use the code showed in there, but change this line of code:

sFormulaTemplate = "=IF(ISERROR(_form_),"""",_form_)"

to:

sFormulaTemplate = "=SUM(_form_)"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com