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

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

Do you mean MoreFunc from 'Morefunc for Excel'
(http://xcell05.free.fr/morefunc/english/#Functions)


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30437

thanks a ton. it works...

Bernard Liengme wrote:
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
HI Team,

[quoted text clipped - 7 lines]
thanks a ton.
vandana

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