ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   going from digits to real text (https://www.excelbanter.com/excel-discussion-misc-queries/129442-going-digits-real-text.html)

Robert

going from digits to real text
 
I've seen it, it must be in one of my manuals but I can't find it now I
need it.

Say - cell A1 contains the number "12". What Function can convert that
to "twelve"?

Can it be done with a Function or is VBA needed for this?

If it can be done in VBA, can an output language be choosen if I want
"douze" or "zwölf"?

Help is appriciated!

Robert

David Biddulph

going from digits to real text
 
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
David Biddulph

"Robert" wrote in message
...
I've seen it, it must be in one of my manuals but I can't find it now I
need it.

Say - cell A1 contains the number "12". What Function can convert that to
"twelve"?

Can it be done with a Function or is VBA needed for this?

If it can be done in VBA, can an output language be choosen if I want
"douze" or "zwölf"?

Help is appriciated!

Robert




pinmaster

going from digits to real text
 
Hi,

Check out the link below, I think with some tweaking it could be made to
output in any language.


HTH
Jean-Guy

"Robert" wrote:

I've seen it, it must be in one of my manuals but I can't find it now I
need it.

Say - cell A1 contains the number "12". What Function can convert that
to "twelve"?

Can it be done with a Function or is VBA needed for this?

If it can be done in VBA, can an output language be choosen if I want
"douze" or "zwölf"?

Help is appriciated!

Robert



All times are GMT +1. The time now is 04:26 PM.

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