converting amount into figures

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

100/-
should automatically convert into;;;;

one hundred only

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

--

HTH

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


"IRFAN AHMAD" <IRFANAHMAD@discussions.microsoft.com> wrote in message
news:7A1570B6-5F0F-4E5C-8C5D-4F5BF6F7943F@microsoft.com...
> Is there any wany to convert any amount into figure automatically.
>
> 100/-
> should automatically convert into;;;;
>
> one hundred only