Microsoft Office Tutorials and References
In Depth Information
Click and drag to
select the cells you
want to convert.
Right-click the selected
A contextual menu
Click Paste Special.
l The Paste Special dialog box appears.
Click Multiply (
l The numbers now appear on the right
side of their cells, and you can use them
in mathematical formulas.
Did You Know?
Excel can convert text-based numbers to actual numbers. Click the Office button and then click Excel
Options. The Excel Options dialog box appears. Click Formulas. In the Error Checking Rules section,
select Numbers Formatted as Text or Preceded by an Apostrophe ( changes to ). Excel flags
cells containing text by placing a green flag in the upper-left corner. Click the menu button
appearing alongside any cells with this error. Click Convert to Number. If Excel is able to convert
the text to a number, the numbers will right-align. This method does not always work.
Chapter 3: Copy, Format, and More