Is there an Excel Function that coverts: 37 to thirty seven?

[tgirl26x]

It's Excel 2003 if it makes a difference. I am doing a payroll workbook and
need to get the check amount to print on the check without having to type out
the amount everytime.

 

[Ron Rosenfeld]

It's Excel 2003 if it makes a difference. I am doing a payroll workbook and
need to get the check amount to print on the check without having to type out
the amount everytime.

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

Then use the NBTEXT function
--ron

 

[Gord Dibben]

Check out the several different methods at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP