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.

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" wrote:

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.

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

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

On Sun, 21 Nov 2004 03:43:02 -0800, Rao Ratan Singh
wrote:

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