Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conversion from currency value to currency text format
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 "gdselva " schrieb im Newsbeitrag ... Hi, I have one question. i.e. Suppose I am entering the value in the Cell A1, Input: A1 contains 63,653 Output B1: I need the output in B1 cell. i.e. Sixty Three Thousand six hundered and fifty three only. The Conversion range from 0 to Millions. Do you have any idea, how to do this through Formulas or VBA Macros. Thanks, Selvam K --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conversion from currency value to currency text format
Thanks Frank
I will see and get back to you. regards, Selvam -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
Column with currency & text - how to format? | Excel Discussion (Misc queries) | |||
Changing cell format from text to currency | Excel Worksheet Functions | |||
Currency format in visual basic text box | Excel Discussion (Misc queries) | |||
Text Box Currency format with two decimal places | Excel Programming |