converting numbers to text

RAINDOG · May 4th, 2002, 07:48 AM

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 · May 4th, 2002, 07:51 AM

hello

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

sen_edp · May 4th, 2002, 08:01 AM

see this and copy the code

http://support.microsoft.com/default...;EN-US;q140704

Aladin Akyurek · May 4th, 2002, 08:13 AM

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 ]

Tom Schreiner · May 4th, 2002, 08:16 AM

Thanks for the function!
I like it.
Tom

May 4th, 2002, 07:51 AM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello be more concise, give an example of what you want ! __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 4th, 2002, 07:48 AM	#1
RAINDOG New Member Join Date: May 2002 Posts: 1	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 ]

May 4th, 2002, 08:01 AM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	see this and copy the code http://support.microsoft.com/default...;EN-US;q140704

May 4th, 2002, 08:13 AM	#4
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	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 ]

May 4th, 2002, 08:16 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Thanks for the function! I like it. Tom