Hi,
I'm trying to replace all the commas in my report (in text boxes). I know it would be quicker to edit regional settings, but it may have impact on other numbers. I have a number 5.00 and 98.54, I want to have 5,00 and 98,54. This formula works well with number 98.54 =Replace(Str$([MyNumber]),".",","). However it doesn't work with 5.00, it shows 5. Any thoughts?
I'm trying to replace all the commas in my report (in text boxes). I know it would be quicker to edit regional settings, but it may have impact on other numbers. I have a number 5.00 and 98.54, I want to have 5,00 and 98,54. This formula works well with number 98.54 =Replace(Str$([MyNumber]),".",","). However it doesn't work with 5.00, it shows 5. Any thoughts?
Comment