PDA

View Full Version : Solved: "formatted" number - Need Help



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.

mdmackillop
02-26-2008, 12:26 AM
I'm surprised it works at all!
Try
=IF(A100<>"","APR rate is "&TEXT(A100/100,"0.0%"))
or
Custom format your cell as "Your APR rate is " 0.0 "%" and enter =A100

joelle
02-26-2008, 09:17 AM
Thank you Sir -- I'll give it a try and post back.
:)