ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to convert FIGURES in one column to WORDS in another column? (https://www.excelbanter.com/excel-discussion-misc-queries/57355-how-convert-figures-one-column-words-another-column.html)

Shashank Virkar

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.





Ron Coderre

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