not summing all the cells
 

I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this?

not summing all the cells
 

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

"Alina Roumania" wrote:

I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this?

not summing all the cells
 

Format the Column as any number format (not text).
Copy any empty cell and select your Column again.
PasteSpecial-Value-Add OK.



--
Regards
Dave Hawley
www.ozgrid.com
"Alina Roumania" <Alina wrote in message
...
I wanted to sum the values from an column but for some cells it doesnt sum
it
to the total. Why is this?