Currency to Text

[sean]

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

 

[Bob Phillips]

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