Is there a way to format a value as accounting to mimic the same format in Excel?   For example: $     0.99 $     1.00  $   10.00  $ 100.00   (the currency sign is left aligned while the numeric value is right aligned)   Thanks! ... View more

I'm trying to perform a roundup function to mimic the function in Excel where I want to round up to the nearest decimal. For example I would like to round -0.2011 to -.202   I've tried round, ceil, and floor but I can't seem to get it to round at the decimal level, only the integer level.   Any help would be greatly appreciated.   Thanks!  ... View more