View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Colin is offline
external usenet poster
 
Posts: 86
Default Formatting and adding cells formatted to 2 decimal places

Is there any way that I can "Autosum" a column which has numbers formatted to
2 decimal places - were the "Autosum" adds the numbers as shown in the cell
(not the numbers with full decimals). e.g. 1.2345 will show as 1.23 but when
added includes the,0045 and shows an answer which does not add up according
to the info displayed?