MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing numerical entries to text.


Posted by Gary Forster on September 06, 2001 10:56 AM

When working I am often required to confirm a value using words.

i.e. £1,234.56 (One Thousand, Two Hundred and Thirty Four Pounds and Fifty Six Pence).

Is there any way Excel can produce the text from a number?


Posted by Barrie Davidson on September 06, 2001 11:06 AM

Have a look at http://www.barasch.com/excel/numb2words.htm