converting numbers to text

[RAINDOG]

I am designing a payroll spreadsheet and would like to convert the result of my "net earnings" formula into text. my goal is to print a check with text and numbers...does anyone know how?!?!?

for example: net earnings = $1.00
i need: One dollar
This message was edited by RAINDOG on 2002-05-04 06:55
This message was edited by RAINDOG on 2002-05-04 06:59

 

[sen_edp]

hello

be more concise, give an example of what you want !

 

[sen_edp]

see this and copy the code

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q140704

 

[Aladin Akyurek]

You could use NUMTEXT from Morefunc add-in downloadable from:

http://longre.free.fr/english/index.html
This message was edited by Aladin Akyurek on 2002-05-04 07:20

 

[Legacy 98055]

Thanks for the function!
I like it.
Tom