Data in excel not converting to numbers

Is your data in Excel getting converted to exponential format? Know from our experts how to prevent this from happening.

I have copy-pasted some data from a word file to excel sheet. In the word file, there was some data in tables, which I copied and pasted in excel too. Now the data in table from Word file in excel are not working.
I tried converting them to numbers by going into format option but, only a few data in cells converted to numbers but rest remained as it is .i.e. not converting to numbers.

When I add the cells the results are the addition of a few cells only and not all. Those cells that are not converted to numbers do not add up during the addition of cells.

I even removed all formatting from the excel sheet but the problem still persisted.

Any help would be welcome as I don't want to type each number manually. Yes, the content of the cell gets converted when I type manually but not otherwise.