ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format dollar amounts for check printing (https://www.excelbanter.com/excel-discussion-misc-queries/56388-re-format-dollar-amounts-check-printing.html)

Bob Phillips

Format dollar amounts for check printing
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dford" wrote in message
...
I would like to format a number to print amount on a check. For example:
$5,280.25 Format to: Five thousand two hundred eighty and 25/100 dollars





All times are GMT +1. The time now is 12:56 PM.

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