- Enter any number in a cell.
- Copy it (Ctl-C).
- Select the range that you want converted to numbers.
- Select the menu options Edit, Paste Special.
- Select "multiply" on the pop-up form.
- The range you selected should now contain numbers, not text.
Friday, March 26, 2010
converting text to numbers in Excel
I found a helpful trick in Microsoft's Excel help for converting text to numbers in a range of cells. Thought I'd pass it along.