HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED

DEAR GROUP MEMBERS I WANNA TO KNOW THE PROSEDURE TO CONVERT A CELL VALU IN
aMOUNT (I.E 1520/-) IN WORDS (I.E. ONE THOUSAND FIVE HUNDRED TWENTY ONLY) IN
OTHER CELL

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"VISHU" <[email protected]> wrote in message
news:[email protected]...
> DEAR GROUP MEMBERS I WANNA TO KNOW THE PROSEDURE TO CONVERT A CELL VALU IN
> aMOUNT (I.E 1520/-) IN WORDS (I.E. ONE THOUSAND FIVE HUNDRED TWENTY ONLY)
IN
> OTHER CELL