not summing all the cells

  • Thread starter Thread starter Alina Roumania
  • Start date Start date
A

Alina Roumania

I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this?
 
Maybe some of the numbers have been formatted as text, are any of them
left-aligned instead of right-aligned? To convert text cells to number
format you will need to highlight them and use Format->Cells to set the
format to number, then click on each cell and press F2 followed by Enter as a
bug in Excel means text cells won't convert immediately back to number unless
you re-enter the data.

Andrea Jones
www.stratatraining.co.uk
 
Format the Column as any number format (not text).
Copy any empty cell and select your Column again.
PasteSpecial-Value-Add OK.
 
Back
Top