Converting #'s to words???? can I do it

[Rosesemails]

Im trying to find out if there is a formula or someway that if I put a Dollar amount in one cell that it would convert it to words onto another cell
Can anyone help
thanx, Rose

 

[brettvba]

what words did you want?

 

[brettvba]

if the dollar is in g19

=IF(G19="$","Dollar","No Dollar")
put the formula in g20 or any othe cell
This message was edited by brettvba on 2002-04-30 13:41

 

[Aladin Akyurek]

On 2002-04-30 13:28, Rosesemails wrote:
Im trying to find out if there is a formula or someway that if I put a Dollar amount in one cell that it would convert it to words onto another cell
Can anyone help
thanx, Rose

Use NUMTEXT from morefunc add-in by Longre, downloadable at:

http://perso.wanadoo.fr/longre/excel/downloads/

It's in English.

 

[Jay Petrulis]

Just to be complete, the following post from Harlan Grove does the reverse -- from words to numbers.

http://groups.google.com/groups?hl=...w2.1308871@bgtnsc05-news.ops.worldnet.att.net

...and true to Harlan's style, he does something really clever *AND* takes a small jab at an Excel MVP in his reply.

Bye,
Jay