convert numbers and amount into currency text

[nadjalil]

Dear All
i have a payment template where i need to instruct my bank to make payment in different currencies and i have to put amount in numbers and words. i want when i put amount in number it convert into text automatically, we are using this formula to convert number into words "=ConvertCurrencyToEnglish(B21)" but we have a problem it's only considering USD and do not display other currencies.
could you please advise us how i can sort this out or if you have any macro please share with me to resolve this issue....

attached is the file where i put number in B21 and need to convert it in B22.
thanks for your kind help.

Best regards

 

[Khalid NGO]

Hi,

See the attached.

For example if your cell B5 having value = 1005.5

Use currencies as follows:

=SpellCurr(B5)
Rupees One Thousand and Fifty Paisas Only

=SpellCurr(B5,"Dollar","S","Cent","S")
One Thousand Dollars and Fifty Cents Only


Similarly:
=SpellCurr(B5,"Pound","S","Pence","S")
One Thousand Pounds and Fifty Pences Only

=SpellCurr(B5,"ABC","S","XYZ","S")
One Thousand ABCs and Fifty XYZs Only

Regards,


PS: Thread moved to VBA