Is there an equivalent formula to trunc() for currency types? I could obviously use trunc() on the numeric type, but I want the output to be currency so that when the data is exported to Excel, it formats the negative amounts as (1000) instead of -1000. I've tried using just round(), but that still gives me 500.00 and I want just 500.