View Single Post
  #1   Report Post  
Dave O.
 
Posts: n/a
Default help with excel cell formatting

In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When
i drag my formula it creates in every cell $0.00 this is affecting my
average at the bottom. How do i keep the formula but loose the $0.00?
Thank you for your help!