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

[Guest]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)