+1. Thanks. Is it also possible to display only 2 digits after the '.'? Like 1.23?
–
GowthamMar 9 '12 at 16:21

you want to have a custom display and trim the number in the same cell as the original number? No, I don't think that's possible. I can do that in a new column though, but not with the original data.
–
RaystafarianMar 9 '12 at 16:51