LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Curtis A
 
Posts: n/a
Default In Excel how can a number automatically display in text form

Is it possible to make Microsoft Excel 2002 automatically display a number in
written form, $3,123.50 result as Three Thousand, One Hundred
Twenty-Three and 50/100. Is there a function or macro availble to accomplish
this in an Excel spreadsheet.
 
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
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
Can excel automatically number itself each time you open a documen Alesha Excel Discussion (Misc queries) 1 January 11th 05 07:40 PM
Need excel formula to display 28.50hrs in HRS & MINS? rbc Excel Worksheet Functions 4 January 6th 05 12:21 PM
How do I pick a number from a list in Excel? pugsly8422 Excel Worksheet Functions 4 January 3rd 05 06:07 PM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 08:53 PM


All times are GMT +1. The time now is 02:59 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"