CONVERT NUMBER TO TEXT E.G 1000 TO "ONE THOUSAND"

[Guest]

I WANT TO CONVERT CURRENCY NUMBER IN REASABLE NUMBER TEXT CONVERSION

E.G

1,000 TO "ONE THOUSAND"
2,950 TO "TWO THOUSAND NINE HUNDRED FIFTY"

 

[scottymelloty]

You could use a vlookup, on 1 excel sheet in column A put all th
numbers you need to convert ie 100, 200, 300 etc , in column B put i
what you would like to convert these into ie, Column A 100, Column
One Hundred

Then on another sheet say in column B Click on the function bar doubl
click vlookup , for lookup_value click on the cell where you will ente
data, for table_array highlight the two columns you typed in on th
other sheet (ie it should read (A1:B1000) , UNDER COL_INDEX_NUM put 2
and range look up put zero and enter,

whatever you type in column A Now it will look up on the other shee
what it is equal to so if you type in 100 it would bring up One Hundre
in Column

 

[sulprobil]

Google for "Excel spellnumber" ...

HTH

 

[Gord Dibben]

IMRAN

Check out the info and links provided by Bob Phillips.

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

Gord Dibben Excel MVP