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.
Find the video lesson that you want – Index to all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
[…] you have a few minutes, I invite you to visit. There are now 15 short video lessons posted on the site. My goal is to create a 3 to 4 minute video for each concept. So far so […]