ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there an Excel Function that coverts: 37 to thirty seven? (https://www.excelbanter.com/excel-worksheet-functions/107861-there-excel-function-coverts-37-thirty-seven.html)

tgirl26x

Is there an Excel Function that coverts: 37 to thirty seven?
 
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

Is there an Excel Function that coverts: 37 to thirty seven?
 
On Wed, 30 Aug 2006 16:44:02 -0700, tgirl26x
wrote:

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

Is there an Excel Function that coverts: 37 to thirty seven?
 
Check out the several different methods at Bob Phillips' site.

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


Gord Dibben MS Excel MVP


On Wed, 30 Aug 2006 16:44:02 -0700, tgirl26x
wrote:

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.




All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com