number to words

R

roquipac

Is there a way in excell to change a number in a cell to a word format? For example, the number 1000 will changed to one thousand pesos.
 
F

Frank Kabel

Hi
Try doing a Google search and you'll find many macros/procedures to
convert numbers to text. Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods
 
Top