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
|
|||
|
|||
Have a look here
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q95640 -- 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! |
#3
|
|||
|
|||
http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP 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! |
#4
|
|||
|
|||
Thanks, Paul, and sorry for the duplication. I looked at
the article--looks like it will do what I want to. But, it doesn't put this function in Excel, and I don't know how to do that either. Little help? -----Original Message----- Have a look here http://support.microsoft.com/default.aspx?scid=kb; [LN];Q95640 -- 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! . |
#5
|
|||
|
|||
It is a function, so it will work in Excel.
Just insert a new module, and copy the code into that. The function can then be called form a worksheet or another VBA procedure as shown. -- HTH RP wrote in message ... Thanks, Paul, and sorry for the duplication. I looked at the article--looks like it will do what I want to. But, it doesn't put this function in Excel, and I don't know how to do that either. Little help? -----Original Message----- Have a look here http://support.microsoft.com/default.aspx?scid=kb; [LN];Q95640 -- 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 |