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"

What if the number is 12,575.98?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Kassie" <j.kasselman@ATlantic.net.removeAT> wrote in message
news:E7B9BFA1-F947-4E94-9C7C-B5F76D5F9448@microsoft.com...
> 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"

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" <j.kasselman@ATlantic.net.removeAT> wrote in message
> news:E7B9BFA1-F947-4E94-9C7C-B5F76D5F9448@microsoft.com...
> > 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"
>
>