spellnumber twice

[nowfal]

Hi,
I would like to know, is it possible to have two types of spell number in a single sheet. If possible,please explain. . I wanted in cell A1 currency dollar(100.23 to One hundred Dollars and twenty three cents, in A8 currecy sterling pound(100.23 to One hundred sterling Pound and twenty three pence) . Any suggestions?
thanks in advance
with regards
nowfal

[dominicb]

Good evening Nowfal

This can only be handled by getting into custom function territory and writing your own. I have a free add-in available to anyone who asks for it (dominic@dom-and-lis.co.uk) which will handle this through a custom formula which can give the result in £, $ and Euros. Please send me an e-mail if you would like to use this.

HTH

DominicB

[nowfal]

thanks dominic
my e mail address is jebi_babu@yahoo.com
please send that add-in to the above address.
with regards
nowfal

[nowfal]

Dominic between jebi and babu there is underscore jebi_babu