Select the range consisting of all the cells you need to convert (making sure that the first cell in the range needs to be converted). ...Click the warning symbol in the first cell.From the drop-down, select Convert to Number, and all cells in the selected range will be modified, turning the numbers to true numbers.