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