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
|
|||
|
|||
Text
This might sound like a crazy question, but if excel can
do this it would be amazing. If you type a dollar amount in cell A1, can you have cell A2 put it in words?? Example: A1 = $10.00. A2= Ten dollars |
#2
|
|||
|
|||
Text
Hi
there're some macros/procedures to convert numbers to text. e.g. MS Knowledge Base: http://support.microsoft.com/default...B;EN-US;213360 http://support.microsoft.com/default...;EN-US;140704& Free Addin MOREFUNC-DLL which includes a UDF for this task (for various languages): http://longre.free.fr/english/ or have a look at http://www.bygsoftware.com/examples/...s/num2wrds.zip It's in the "Accountants" section on page: http://www.bygsoftware.com/examples/examples.htm It contains two methods -- Regards Frank Kabel Frankfurt, Germany John wrote: This might sound like a crazy question, but if excel can do this it would be amazing. If you type a dollar amount in cell A1, can you have cell A2 put it in words?? Example: A1 = $10.00. A2= Ten dollars |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Any way of forcing Plain Text Format universally? | Astra | General Discussions | 0 | June 4th, 2004 09:34 AM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
Vertical Text Orientation | Paul Anderson [MSFT] | Visio | 0 | May 11th, 2004 05:16 PM |
Column separator crosses through wrapped text box | Bob S | Page Layout | 0 | April 25th, 2004 09:52 PM |
Extracting text | Nemo | Worksheet Functions | 3 | April 6th, 2004 02:33 PM |