**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