How to Convert Numeric Values into Text Values with a Formula

[Vijay]

Hello,

I want to convert numeric values into text values. Is
there any formula for it.
example;
$133,569.00 i want this number to be automatically
displayed as One Hundred Thirty Three Thousand Five
Hundred Sixty Nine and Zero Cents. Is there a way i can do
this

 

[Don Guillett]

Have you looked in the archives?

 

[immanuel]

Take a look at:

http://support.microsoft.com/default.aspx?scid=140704

/i.

 

[Peo Sjoblom]

You can download Morefunc from Laurent Longre which has many useful
functions and among them
NUMTEXT which does what you want

http://longre.free.fr/english/