Number with % symbol to words

**udprocks** · 01-01-2021, 03:45 AM

Greetings Dear Gurus!!!

Happy new year to all sir's.

I am using excel 2007 Need to convert like

12% to covert like below in words

Twelve percent

Is this possible?

Thanks in advance

Best
Jitendra

**vba_php** · 01-01-2021, 04:26 AM

nope, it isn't. not without heavy customization. google search? plug in? 3rd party software? that's your only hope I believe. start here:

https://www.google.com/search?q=ms+e...word+translate

**AliGW** · 01-01-2021, 04:34 AM

I'd start here: https://www.extendoffice.com/documen...-to-words.html

**udprocks** · 01-01-2021, 05:39 AM

Originally Posted by AliGW

I'd start here: https://www.extendoffice.com/documen...-to-words.html

Thank you mam.

**udprocks** · 01-01-2021, 05:40 AM

Originally Posted by vba_php

nope, it isn't. not without heavy customization. google search? plug in? 3rd party software? that's your only hope I believe. start here:

https://www.google.com/search?q=ms+e...word+translate

Thank you for clarifications.

**AliGW** · 01-01-2021, 05:40 AM

I'm female, not male! But you are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

**udprocks** · 01-01-2021, 05:43 AM

Originally Posted by AliGW

I'm female, not male! But you are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Edited and updated. 😊

**AliGW** · 01-01-2021, 05:47 AM

Thank you.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**Bo_Ry** · 01-01-2021, 06:07 AM

Please try

=TRIM(INDEX(one,INT(MOD(A1*100/10^2,10))+1)&IF(INT(MOD(A1*100/10^2,10))," Hundred ","")&INDEX(CHOOSE({2;1;2;2;2;2;2;2;2;2},Ten,Ty&" "&one),MOD(A1*100/10^1,10)+1,MOD(A1*100/10^0,10)+1)&IF(INT(A1*100),""," Zero")&" Percent")

Where one, Ten, Ty are range name
One
={"","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"}

Ten
={"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"}

Ty
={"";1;"Twenty";"Thirty";"Forty";"Fifty";"Sixty";"Seventy";"Eighty";"Ninety"}