right click on the cell where you have the formula, click Format
Cells..., then on Number tab click Number from Category list, on right
side change Decimal places to 2 and press Ok.


Sam Wrote:
eg. =C3+D5-J5

then I want the answer which will be a changing number to round up to
two
decimal places from the four that will result

4.5671 to 4.58


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=570994