Converting number into words

[vandana via OfficeKB.com]

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

 

[Bernard Liengme]

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

 

[royUK]

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)

 

[vandana via OfficeKB.com]

thanks a ton. it works...

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