software

I have some currency in US$ in once col. and I want to convert it to Text:
for expample

A1=$4,500 B1=lt;here i wantgt; Four Thousand Five Hundred

can anyone let me know any tool available for this or no? or is there any
simple formula which I can use

xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten

quot;ARTquot; gt; wrote in message ...
gt;I have some currency in US$ in once col. and I want to convert it to Text:
gt; for expample
gt;
gt; A1=$4,500 B1=lt;here i wantgt; Four Thousand Five Hundred
gt;
gt; can anyone let me know any tool available for this or no? or is there any
gt; simple formula which I can use
Hi Niek
That was a great help,
It works that way
Anant

quot;Niek Ottenquot; wrote:

gt; xldynamic.com/source/xld.xlFAQ0004.html
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;ARTquot; gt; wrote in message ...
gt; gt;I have some currency in US$ in once col. and I want to convert it to Text:
gt; gt; for expample
gt; gt;
gt; gt; A1=$4,500 B1=lt;here i wantgt; Four Thousand Five Hundred
gt; gt;
gt; gt; can anyone let me know any tool available for this or no? or is there any
gt; gt; simple formula which I can use
gt;
gt;
gt;