number format
346165Apr 4 2008 — edited Apr 4 2008Hi,
I have a $ amount like this: $100.50, but the users want it to be round up to $101 without any decimal. I can use round function to round up the number but how can I put the $ in front of it.
Thanks,
Helen