Select any blank cell, right clickselect Copyhighlight your data range
right clickPaste specialselect AddOK

"Japhy" wrote:

hello,
I copied and pasted some data from a web page into an excel ss.
1 column as fractions like:
0.10
0.10
0.20
0.10
0.20

I can't add up the column. I have them formatted as numbers, but
excel doesn't recognize them as such. All attempts to add from this
column equals 0.
Any ideas?
thanks