Microsoft Office Tutorials and References
In Depth Information
Fixing Non-Numeric Numbers
Fixing Non-Numeric Numbers
If you import data from other sources, you may have discovered that Excel sometimes does not
import values correctly. Specifically, you might find that Excel is treating your numbers as text.
For example, you might sum a range of values and find that the SUM formula returns 0 — even
though the range apparently contains numeric values.
Often, Excel will notify you of these “non-numbers” and display a Smart Tag that lets you convert
the text to numbers. If that Smart Tag isn’t displayed, you can use this technique to force Excel to
change these non-numeric numbers to actual values. Follow these steps:
1. Activate any empty cell on your worksheet.
2. Press Ctrl+C to copy the empty cell.
3. Select the range that contains the problematic values.
4. Choose Home
Paste Special to display the Paste Special dialog box.
5. In the Paste Special dialog box, select the Add operation.
6. Click OK.
Excel adds nothing to these values, but in the process it coerces those cells to be actual values.
Search JabSto ::

Custom Search