Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to text
Is there an easy way to code a macro to convert numbers to
text. For example 22,600.00 is converted to twenty two thousand six hundred. I know I could write code using "mid" to evaluate each number in 22,600.00 but that seems cumberson. Any ideas would be greatly appreciated. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert numbers to text
Mike wrote:
Is there an easy way to code a macro to convert numbers to text. For example 22,600.00 is converted to twenty two thousand six hundred. I know I could write code using "mid" to evaluate each number in 22,600.00 but that seems cumberson. Any ideas would be greatly appreciated. Thanks for the help. Hi Mike This is common question. Try doing a Google search and you'll find a lot. Below a short list for this topic: 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 Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Numbers stored as Text to Numbers | Excel Discussion (Misc queries) | |||
convert numbers stored as numbers to text | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |