A simpler (and yet, not really
) way would be what you had, with a small addition:
N = round(N)? (N&".00"):(round(N*100)/100)
Using a fancy query thingy... It's actually not simpler at all, it's just a different kind of complicated. Simpler to ME because I use stuff like this all the time.
If you've never seen this before, it's checking to see if there even ARE any decimals; if there aren't, just add a ".00" at the end. If there are, do what you originally do.
(Edit: removed a pair of parentheses from the expression, just tested it and it gave a syntax error. Other than that it works fine)SullyTheStrange2012-08-30 09:33:43