If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Number to text (checkbook)
could anybody tell me how to set Excel to write out a
number in English? I need a way for Excel to refer to a number in one cell/worksheet and turn it into a checkbook type nuber in another (e.g., "112.19" becomes "One Hundred Twelve and 19/100" or "One Hundred Twelve Dollars and 19 cents" ). Please Help! |
#2
|
|||
|
|||
see your post in misc, please do not post to more than one group at a time
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** wrote in message ... could anybody tell me how to set Excel to write out a number in English? I need a way for Excel to refer to a number in one cell/worksheet and turn it into a checkbook type nuber in another (e.g., "112.19" becomes "One Hundred Twelve and 19/100" or "One Hundred Twelve Dollars and 19 cents" ). Please Help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Text field (with numbers) DataType to Number | Michael Miller | Database Design | 1 | November 4th, 2004 08:04 PM |
can't import number into text field | Martin Lord | General Discussion | 1 | October 19th, 2004 11:34 PM |
Text or Number | rexmann | General Discussion | 2 | August 25th, 2004 04:36 PM |
fromatting a cell as a number that contains text and a number | howiefan | General Discussion | 0 | August 23rd, 2004 05:03 PM |
Format problem : "Text" & Number; Number -> Standard format. How? | BerHav | Setting Up & Running Reports | 0 | August 19th, 2004 06:31 PM |