Select a new cell in a different column. Type the formula =Value () and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2. Press ...