Convert numbers stored as text to numbers - Microsoft …
https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885
1. Select a column2. Click this button3. Click Apply4. Set the format 2. Use the VALUE functionIn one of the cells of the new column, type =VALUE() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example it's cell E23.
2. Use the VALUE functionIn one of the cells of the new column, type =VALUE() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example it's cell E23.
DA: 78 PA: 38 MOZ Rank: 91