I am not sure what you mean by "the more excel formula"
But here is a suggestion:
=SUBSTITUTE(NBTEXT(850.50,,,,,"Fils","Fils"),","," &")
I cannot test my suggestion as I do not have the NBTEXT function
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"vandana via OfficeKB.com" <u44172@uwe wrote in message
news:8d52c9b2fcf31@uwe...
HI Team,

i have installed the more excel formula in my system and used the below
formula to change the number intowords.

=NBTEXT(850.50,,,,,"Fils","Fils") = Eight hundred fifty, fifty fils

i need to have "&" in place of comma can you please help.

thanks a ton.
vandana

--
Message posted via http://www.officekb.com