MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting numbers to a word string


Posted by Mark Tinderholt on October 02, 2001 2:55 PM

I'd like to have a cell convert a number, i.e.. $7,352.35 to text or words, i.e.. "Seven thousand three hundred fifty two dollars and thirty five cents".

Is that possible???


Posted by IML on October 02, 2001 3:04 PM

This is available when you use the free ASAP utility available at
www.asap-utilities.com
Once installed, look under the numbers option


Posted by Paul on October 02, 2001 3:28 PM

Also look at http://geocities.com/aaronblood/pages/vba.html
Look for num_2_text.zip

I'd like to have a cell convert a number, i.e.. $7,352.35 to text or words, i.e.. "Seven thousand three hundred fifty two dollars and thirty five cents".