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

Rosesemails · Apr 30th, 2002, 02:28 PM

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 · Apr 30th, 2002, 02:38 PM

what words did you want?

brettvba · Apr 30th, 2002, 02:39 PM

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 · Apr 30th, 2002, 02:42 PM

Quote:

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 · Apr 30th, 2002, 02:56 PM

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

http://groups.google.com/groups?hl=e...rldnet.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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 02:28 PM	#1
Rosesemails New Member Join Date: Apr 2002 Posts: 1	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

Apr 30th, 2002, 02:38 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	what words did you want?

Apr 30th, 2002, 02:39 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	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 ]

Apr 30th, 2002, 02:56 PM	#5
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Just to be complete, the following post from Harlan Grove does the reverse -- from words to numbers. http://groups.google.com/groups?hl=e...rldnet.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