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 ([email protected]) 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 (e-mail address removed)
please send that add-in to the above address.
with regards
nowfal

 

[nowfal]

Dominic between jebi and babu there is underscore jebi_babu