ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   from a cell which has numbers how to get it spelled (https://www.excelbanter.com/excel-worksheet-functions/99146-cell-has-numbers-how-get-spelled.html)

sridhar

from a cell which has numbers how to get it spelled
 
please somebuddy help me with a formula from a cell which has 3564 in numbers
and in the other I want in words like three thousand five hundered and sixty
four

Bondi

from a cell which has numbers how to get it spelled
 

sridhar wrote:
please somebuddy help me with a formula from a cell which has 3564 in numbers
and in the other I want in words like three thousand five hundered and sixty
four


Hi,

Maybe you can use this link:

http://www.ozgrid.com/VBA/ValueToWords.htm

Regards,
Bondi


Bob Phillips

from a cell which has numbers how to get it spelled
 
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sridhar" wrote in message
...
please somebuddy help me with a formula from a cell which has 3564 in

numbers
and in the other I want in words like three thousand five hundered and

sixty
four





All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com