About =bahttext()

[Rao Ratan Singh]

Dear Sir or Mam,
Any body can help i will be very grateful to him

basically i want to do that numeric value to displya in text value in english.

for examplse
=bahhtext(125) = One hundred Twenty fice.

How it can be pls help me.

 

[Frank Kabel]

Hi
in the links I posted there're several other addins which just provide this
kind of functionality. e.g. install the MoreFunc.xll addin for this

 

[Rao Ratan Singh]

Sir,
Thank u for reply. I install this patch according yr guideline but it is not
working. After using this function =pbtext(100) it is only shows processing
and after some time hangs my system.

So pls any other solution pls.

Thanks

 

[Gord Dibben]

Rao

The NBTEXT function from Laurent Longre's Morefunc.xll has given problems.
Don't know if he has fixed or not.

See this google thread.

http://snipurl.com/asoc

I would use one of the several other functions you have been pointed to.

Gord Dibben Excel MVP