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/ |
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 |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com