Thread: Number Format with Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lizz45ie Lizz45ie is offline
external usenet poster
  
Posts: 20
Default 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"
Reply With QuoteReply With Quote