Here, we multiply each selected cell by 1 in order to force the conversion from a text-formatted number to a regular number. Because we're multiplying the contents of the cell by 1, the result in the cell looks identical. However, Excel actually replaces the text-based contents of the cell with a numerical equivalent.
