To convert text-formatted numbers using Paste Special: 1. Select a blank cell with the General number format. 2. Type '1' in the cell and press ENTER. 3. Copy the value to the Clipboard. 4. Select the cells or ranges with text-formatted numbers. 5. Go to the Home tab, click the arrow below Paste in the Clipboard group, and choose Paste Special. 6. Under Operation, select Multiply, and click OK. 7. Delete the content of the cell used in step 2.