Excel - Convert text values to numbers with Paste Special

Usually when we copy numerical data from other sources (e.g. pdf file, internet, Word, Access) to Excel, it behaves as text. Doing calculations with this "text" data can be a quite challenging but fortunatelly there is work arround to overcome this problem that is - Convert those values from their native text versions to more workable number fields in Excel.

Here's how to do it using Excel's Paste Special feature.
Follow these steps

1. Click a blank cell formatted as a number cell and enter 1 in the cell.

2. Click Ctrl + C   (Copy)

3. Select all the cells that contain the text values that you want to convert.

4. Click Ctrl + Alt + V  (Display the Past Special dialog box)

5. In the Operation section, select Multiply.

6. Click OK.

There you have. Text values quick converted into their numerical values.