Data in excel wont autosum

F

Frusterated

I've copied and pasted some figures from a PDF document, now I cannont get
excel to autosum. There is quite a bit of data and don't really care to
hand jam it. This has worked in the past, but not so cooperative this time.
Any suggestions are appreciated.
 
G

Glenn

Frusterated said:
I've copied and pasted some figures from a PDF document, now I cannont get
excel to autosum. There is quite a bit of data and don't really care to
hand jam it. This has worked in the past, but not so cooperative this time.
Any suggestions are appreciated.
Click to expand...

Excel could be seeing the data as text. Put a zero in an empty cell and then
copy it. Select all of your data and Paste Special / Add.
 
Top