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?