number to text and vice versa

  • Thread starter Thread starter Abdul-Mun'im
  • Start date Start date
A

Abdul-Mun'im

Using MS-Excel, how can I convert a word represents a
number to digits and digits to words represent a number?
Like: Ten 10
9 Nine
 
Hi
for the second question: 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
 
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

nine digits 3
Working with numbers in Excel-Specify # of digits 6
Convert Decimal fractions to binary and vice versa 1
i want to convert decimals into time format 3
Converting a 10 digit serial number to a date of mm/dd/yyyy 7
Using TEXT and &TEXT - display numbers with commas, underline text 2
Data Lookup 3
CONVERT NUMBER TO ENGLISH TEXT 2

Back
Top