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

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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