DollarFormat(number) Michael Corrigan Programmer Endora Digital Solutions 1900 Highland Avenue, Suite 200 Lombard, IL 60148 630-627-5055 ext.-136 630/627-5255 Fax ----- Original Message ----- From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, April 03, 2002 3:07 PM Subject: Re: How do you change this number 70.0500 to 70.05?
Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
