ExcelBanter - HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND (https://www.excelbanter.com/excel-discussion-misc-queries/232302-how-can-convert-number-into-text-e-g-5000-five-thousand.html)

Sachin

HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND

HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND

Jacob Skaria

HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND

You will have to use a macro. Refer

http://www.ozgrid.com/VBA/CurrencyToWords.htm
--
If this post helps click Yes
---------------
Jacob Skaria

"Sachin" wrote:

HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND

All times are GMT +1. The time now is 06:25 PM.