Currency to Value tool;
 

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

A1=$4,500 B1=<here i want 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

Currency to Value tool;
 

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten

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

A1=$4,500 B1=<here i want 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

Currency to Value tool;
 

Hi Niek
That was a great help,
It works that way
Anant

"Niek Otten" wrote:

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten

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

A1=$4,500 B1=<here i want 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