Prev: Keyboard shortcut for current date and time
Next: How to calculate the present value of a security, $5000 @ 7%, 20y.
From: booshi on 2 Jun 2010 00:43
Is it possible to convert, say 1234 to one thousand two hundred and thirty
four


Thanks


From: Jacob Skaria on 2 Jun 2010 01:17
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
>
>
> .
>
 | 
Pages: 1
Prev: Keyboard shortcut for current date and time
Next: How to calculate the present value of a security, $5000 @ 7%, 20y.