Hi Charlie, On Saturday, 11 August 2012 10:54:04 UTC-4, Charlie Noah wrote: > > That did the trick - thanks, Kevin! I did the dollar sign and the comma, > just to be safe. That only leaves the parens for negative amounts, which > some accountants like (but I don't). I can live with that easily. > > AMT ICONV(AMT, 'MCC;$;]MCC;,;]MD2') > *************** ******************************* > $1,200.00 120000 > $-1,200.00 -120000 > -$1,200.00 -120000 > ($1,200.00) >
You don't need to strip out the comma, as "MD2" will handle that ok. As for the parens, use MCC to convert the opening one to a minus sign and to remove the closing one entirely. The following should handle all of the cases that you presented. ICONV(AMT,'MCC;$;]MCC;(;-]MCC;);]MD2') -- Kevin Powick -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
