how to converts a number to text eg. "2" become "two"

K

Kassie

Hi CQ

My 2c worth, I'd set up a table containing the numbers 0 - 9, with their
numeric and text values, and then use a VLOOKUP to get the Two iso 2. Iow,
if you have 2 in A1, then in B1 enter =VLOOKUP(A1,List,2,FALSE)
hth
 
P

Peo Sjoblom

What if the number is 12,575.98?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 
K

Kassie

That is not what CQ asked. Your question is a whole different kettle of
fish, for which I am sure you know the answer.
 

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

Converts HTML and PDF to Word 1
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Finding the proper style field and the numbered paragraph value within the style 0
Creating a Search using a combo box and then creating a report. 4
How to center adjust text above and image in a two column document. 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
How to Create an S-Curve from Custom Field? 0
Finding the right style field in VBA 0

Top