pasted numbers to a column, A10:A30 and sum does not recognize them to add up. so formatted these c

[david_1211]

so formatted these cells to numbers and sum still did not recognize to add, sum them.

[#2]

@david_1211 

Does this work?

Select A10:A30.

On the Data tab of the ribbon, click Text to Columns, then click Finish.