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

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

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

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

"CQ" wrote:

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

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

What if the number is 12,575.98?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Kassie" wrote in message
...
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

"CQ" wrote:

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

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

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

"Peo Sjoblom" wrote:

What if the number is 12,575.98?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Kassie" wrote in message
...
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

"CQ" wrote:

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