Currently Being ModeratedApr 18, 2013 10:28 AM (in response to Johngm)
what format are your cells in that contain the original numbers? Make sure they are in a number format (currencym etc..), and you should be good.
If you can give some more data, maybe a screenshot, we might be able to assist better.
Currently Being ModeratedApr 18, 2013 11:54 PM (in response to Johngm)
Care to share the formula that you're using, or should we just guess?