convert numbers stored as text to real numbers


Use Paste Special and Multiply

Select a blank cell that doesn't have this problem, type the number 1 into it, and then press Enter.
Press CTRL + C to copy the cell.
Select the cells that have numbers stored as text.
On the Home tab, click Paste > Paste Special.
Click Multiply, and then click OK.Type your paragraph here.