ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Currency displayed as full text (https://www.excelbanter.com/excel-discussion-misc-queries/45440-currency-displayed-full-text.html)

Kim

Currency displayed as full text
 
When writing checks, I would like to have Excel recognize the text version of
the currency amount automatically (example, $6,100.00 to display as "Six
thousand one hundred dollars".

Paul B

Kim, have a look here,

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kim" wrote in message
...
When writing checks, I would like to have Excel recognize the text version

of
the currency amount automatically (example, $6,100.00 to display as "Six
thousand one hundred dollars".





All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com