Convert number in to words
Hi, I want to convert the numbers in a cell in to corresponding words. I saw a reply in the forum where in the conversion was in terms of Dollars and Cents. Would you please suggest me a solution to convert a number in the normal format? eg: 123.5 should be displayed as "ONE HUNDRED TWENTY THREE POINT FIVE" Thanks in advance for ur time:) , Harsha -- harshaputhraya ------------------------------------------------------------------------ harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225 View this thread: http://www.excelforum.com/showthread...hreadid=539755 |
Convert number in to words
Make a search in this forum with words "convert to words"! You'll get several
answers. Regards, Stefi €˛harshaputhraya€¯ ezt Ć*rta: Hi, I want to convert the numbers in a cell in to corresponding words. I saw a reply in the forum where in the conversion was in terms of Dollars and Cents. Would you please suggest me a solution to convert a number in the normal format? eg: 123.5 should be displayed as "ONE HUNDRED TWENTY THREE POINT FIVE" Thanks in advance for ur time:) , Harsha -- harshaputhraya ------------------------------------------------------------------------ harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225 View this thread: http://www.excelforum.com/showthread...hreadid=539755 |
Convert number in to words
See this link:
http://www.ozgrid.com/VBA/CurrencyToWords.htm Let us know! "harshaputhraya" wrote: Hi, I want to convert the numbers in a cell in to corresponding words. I saw a reply in the forum where in the conversion was in terms of Dollars and Cents. Would you please suggest me a solution to convert a number in the normal format? eg: 123.5 should be displayed as "ONE HUNDRED TWENTY THREE POINT FIVE" Thanks in advance for ur time:) , Harsha -- harshaputhraya ------------------------------------------------------------------------ harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225 View this thread: http://www.excelforum.com/showthread...hreadid=539755 |
All times are GMT +1. The time now is 08:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com