Convert Text Numbers to Number Numbers in Excel (5 Ways!)
5 Ways to Convert Text Numbers to Numbers
1. Multiply by 1
2. Text to Columns (just push “Finish”)
3. Copy 1 and Paste Special “Multiply”
4. Copy and paste into notepad, then copy and paste back into Excel
5. Run the following VBA code:
With Selection
.NumberFormat = "General"
.Value = .Value
End With