Quote:
| Originally Posted by paul-gte click on the cell, go to format, select currency or number, select amount of decimal places ie 2 and that should do it, sorry if this is not exactly accurate as i cant check on this pc but you get the picture
cheers paul |
Paul,
That is a display format. You may be looking at 3.33, but 3.33333333r is being stored. And more importantly, applied in formulae.
The Round() function is the way to go, round(3.33333,2) returns 3.33
Adrian