View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doc d Doc d is offline
external usenet poster
 
Posts: 1
Default sum() 0.00 result

A report was exported to Excel. When using =sum(start:end) on a numerical
column the result is 0.00. But if use =cell1+cell2+cell3 the result is okay.

Tried using format as numerical, currency, and accounting to no avail.