Hello mdmackillop,
Thanks a lot for the quick reply.
Yes, I did try a "similar" formula in the past but it did not work properly
in Europe (I'm in USA).
I used this (for 14.25%):
=IF(B1>0,TEXT(B1,"##.##%"),"")
and in Europe, they saw this 142.5% !!!
Was it because I used ##.##% instead of having to use 0.00%
as in your formula??
This is much simpler than vba if works. I'll change my formula to
=IF(B1>0,TEXT(B1,"0.00%"),"")
and will ask them to test it.
I'll let you know. Thanks a lot and have a Great 4th!
(it's my sister birthday too, not mine )
Best regards,
Nee