Jul 5, 2011

Convert Text-Format Numbers Using Paste Special

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.

To convert Numbers using paste special:

1) Select a blank cell and verify that its number format.

2) In the cell, type 1, and then press ENTER.
3) Select the cell, and then press CTRL+C to copy the value to the Clipboard.
4) Select the cells or ranges of cells that contain the numbers stored as text that you want to convert.

5) On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special. Under Operation, select Multiply, and then click OK.

6) To delete the content of the cell that you typed in step 2 after all numbers have been converted successfully, select that cell, and then press DELETE.


Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More