joelle
02-25-2008, 04:58 PM
Hello All,
I use Excel 2000 (Windows 2002) for the formula below:
=IF(A100<>"","APR rate is "&TEXT(A100,"0.0%")"
So, when customer types "10.5" in cell A100, I expect to see:
"Your APR rate is 10.5%"
It works for my customers in USA, but the same doc sent in from Europe (Sweden) shows 1.5%, and not 10.5%.
So I add one more leading zero to the formula to say "&TEXT(A100,"00.0%")"
but this is ugly for my US customers -- if thing is less than 10%, say 7%, the option above shows 07.0%. And this customer is using Excel 2003, SP3.
Please is there an elegant workaround? Many thanks.
I use Excel 2000 (Windows 2002) for the formula below:
=IF(A100<>"","APR rate is "&TEXT(A100,"0.0%")"
So, when customer types "10.5" in cell A100, I expect to see:
"Your APR rate is 10.5%"
It works for my customers in USA, but the same doc sent in from Europe (Sweden) shows 1.5%, and not 10.5%.
So I add one more leading zero to the formula to say "&TEXT(A100,"00.0%")"
but this is ugly for my US customers -- if thing is less than 10%, say 7%, the option above shows 07.0%. And this customer is using Excel 2003, SP3.
Please is there an elegant workaround? Many thanks.