![]() |
How to convert FIGURES in one column to WORDS in another column?
I want to get the amounts put in one column in "Figures" to appear it in
another column in "Words" . Is it possible in Excel ? See below to have a clear idea about what I am saying. Example- USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen Thousand Five Hundred Sixty-six & Cents Thirty-eight only" Please Guide, if anybody can. |
How to convert FIGURES in one column to WORDS in another column?
Try this:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Does that help? *********** Regards, Ron "Shashank Virkar" wrote: I want to get the amounts put in one column in "Figures" to appear it in another column in "Words" . Is it possible in Excel ? See below to have a clear idea about what I am saying. Example- USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen Thousand Five Hundred Sixty-six & Cents Thirty-eight only" Please Guide, if anybody can. |
All times are GMT +1. The time now is 06:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com