View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EdMac
 
Posts: n/a
Default Auto Sum and decimilization


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