converting amount into figures

[IRFAN AHMAD]

Is there any wany to convert any amount into figure automatically.

100/-
should automatically convert into;;;;

one hundred only

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)