Have you ever received an Excel file with lots of numbers that weren’t really numbers - the numbers are text and can’t be easily converted. These files can make you crazy when you try to use formulas and the formulas just won’t work.
Fortunately, you can use Paste Special to convert the text to numbers.
The example below shows numbers that are really text in rows 2 thru 13. In row 1, the #1 is formatted as a number. You will need to manually add a #1 to your spreadsheet and make sure it is formatted as a number.
Step 1: Copy the #1 in cell C1
Step 2: Paste Special
- Highlight the cells with the text numbers
- On the menu EDIT > Paste Special
- Operation=Multiply
- Click “OK”
And Voila! All of the text numbers are real numbers that can be used in formulas.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
3 Comments so far (Add 1 more)