[Maintain decimal zeros]

Eric,

 

I was mis-using "FormatNumber" and your suggestion made me take a fresh look. Works great now.

 

Thanks,

Andy

[Maintain decimal zeros]

How do I maintain two decimals if result is ***.00 or ***.x0?

 

Adding ***.00 + ***.00 getting yyy (no decimal, no zeros). Tried adding a ".00" at the end, but if there was a ***.50, my trailing ".00" cancatenated and became, yyy.5.00