converting figure into words in excel

[bobf]

Use a look up table. In column A enter 1, 2, 3 etc. In column B enter one,
two, three etc. Sort the table into column A ascending order. Highlight whole
table and give it a name eg convert. Then use the formula =vlookup(cellref,
convert,2) where cellref is the cell with the field you wish to convert.

 

[Gord Dibben]

Manish

Check out the info and links provided by Bob Phillips.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Gord Dibben Excel MVP

 

[Myrna Larson]

Can you give specific formulas to use with his example, which was 2950 ?