Number Format with Macro
 

I am using a macro to sum some values; if the summed value is greater than
2.5M then the macro returns #NUM!. Here is what I'm using to sum the values:

"=MOD(H3*100,2)0.5"

Number Format with Macro
 

Hi,

This bug is well documented and Microsoft offer a workaround here

http://support.microsoft.com/?kbid=119083

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Lizz45ie" wrote:

I am using a macro to sum some values; if the summed value is greater than
2.5M then the macro returns #NUM!. Here is what I'm using to sum the values:

"=MOD(H3*100,2)0.5"

Number Format with Macro
 

Mike,

I looked at the suggested site for the workaround. I tried a couple version
of my formula; the macro crashed.
Sample formula:

=MOD(MOD(H3*100,2)0.5)

=H3(INT((H3*100,2))0.5



"Mike H" wrote:

Hi,

This bug is well documented and Microsoft offer a workaround here

http://support.microsoft.com/?kbid=119083

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Lizz45ie" wrote:

I am using a macro to sum some values; if the summed value is greater than
2.5M then the macro returns #NUM!. Here is what I'm using to sum the values:

"=MOD(H3*100,2)0.5"