Here are the steps to follow in this lesson:
- Very that all values are actually numbers e.g. use the =COUNT() and =ISTEXT() functions.
- To convert a series a text values to numbers, first select a blank cell and copy it to the clipboard.
- Highlight your text values and choose Edit, Paste Special. In the Paste Special Dialog Box choose ADD.
- All text values are now converted into numbers that can be summed, etc.