Home > IT Answers > Development > Convert numbers to text with VBA (ie 10 to be Ten)
AnandaDebnath
280 pts.
 Convert numbers to text with VBA (ie 10 to be Ten)
Convert numbers to text, String manipulation, VBA, Visual Basic for Applications
I want to conver number to word ie. if 10 it to be Ten, if 540 it to be five hundred forty so on

Software/Hardware used:
ASKED: March 31, 2009  4:34 AM
UPDATED: March 31, 2009  1:51 PM
RELATED QUESTIONS
Answer Wiki:
Hi, The following is the link for converting numbers to text. It can handle decimals as well. http://www.meadinkent.co.uk/xlnumberstext.htm.
Last Wiki Answer Submitted:  March 31, 2009  6:04 am  by  Dreamz1974   515 pts.
All Answer Wiki Contributors:  Dreamz1974   515 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The only thing I can think of is to use switch or if statements for each possible number you want to convert.

mshen
 27,310 pts.
 

I want to convert number to word ie. if 10 it to be Ten, if 540 it to be five hundred forty so on 

Parthibanvba
 10 pts.