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

--
HTH

Bob Phillips

"sean" wrote in message
...
I am creating invoices which show the Total as £ currency. I need to add a
further box that link to this currency No. and then shows it as Text eg
£72
= seventy two pounds.

The other part of this problem is I need the text to show as Nigerian
"Naira" and "Kobo" as the main currency to 2 decimal places.

Any help much appreciated in advance. Cheers