ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Converting number to text (https://www.excelbanter.com/excel-worksheet-functions/265035-converting-number-text.html)

booshi

Converting number to text
 
Is it possible to convert, say 1234 to one thousand two hundred and thirty
four


Thanks



Jacob Skaria

Converting number to text
 
There is no direct functions to convert this. For a VBA solution check out
the below links

http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Jacob (MVP - Excel)


"booshi" wrote:

Is it possible to convert, say 1234 to one thousand two hundred and thirty
four


Thanks


.



All times are GMT +1. The time now is 05:11 PM.

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