Formula to change numbers into words?

[daveed]

Is there a formula/formatting to change numbers into words? Like on a
check $425.00 = four hundred twentry five

 

[Peo Sjoblom]

Only a user defined function

http://longre.free.fr/

a whole set of utilities can be downloaded for free
a description can be found here

http://www.rhdatasolutions.com/morefunc/

 

[friend]

your answer is in the help file

 

[GB]

your answer is in the help file

I am afraid I can't find it

 

[pfsardella]

Here are two links that provide custom functions to handle this :

http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704
http://support.microsoft.com/support/kb/articles/Q95/6/40.ASP

HTH
Paul