Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
close workbook without closing excel and stop recursive function chris Excel Discussion (Misc queries) 3 July 10th 06 08:23 PM
Excel 2003 Slow Function Argument Window [email protected] Excel Discussion (Misc queries) 2 June 28th 05 06:53 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"