You probably have to use an IIF Statement and do some like <cfset num=-10) #IIF(num LT 0,"'(#right(num,len(num)-1)#)'","'#num#'")#
If you dont want. #numberformat(-10,"(__.__)")# Joe ----- Original Message ----- From: "Andrew Peterson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 9:40 AM Subject: Another NumberFormat question - brackets for negative numbers > Hi, > > I cant figure out how to use numberformat to surround negative numbers with > brackets. Well, I can, but if I do, it appears that I also have to > incorporate the _ or the 9 for place settings, which I do not care for. Any > ideas? If there isn't one out there, I will try to roll my own. > > Thanks, > Andrew > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists