Hi Ozgur,
Formatting to 2 decimal places only effects what you see - the 'real'
value remains as calculated. If you use the ROUND function then what
you see is what you have.
HtH
Ed
--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=522613