How to convert numbers to letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI everybody

I've been wondering if it's possible to convert a cell which contains a number to letters to be display in another different cell. If it's possible, please tell us how to do it.

Thanks, Claudio
 
Hi
there're some macros/procedures to convert numbers to text. e.g.
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


If you use for example Morefunc.dll (the function NBTEXT) and your cell
A1 stores the value try the following in cell B1:
=NBTEXT(A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert text to number 2
convert a number to letter 2
Excel Convert word into numbers and back 4
Red cell for negative numbers in Excel 1
Combining Letters and Numbers 1
How to Convert EML to PST? 2
How to add up letters to equal a number value. 1
How do I display a number in writing (letters) 1

Back
Top