Search News Archive

How to identify and convert text values to numbers

Here are the steps to follow in this lesson:

  1. Very that all values are actually numbers e.g. use the =COUNT() and =ISTEXT() functions.
  2. To convert a series a text values to numbers, first select a blank cell and copy it to the clipboard.
  3. Highlight your text values and choose Edit, Paste Special. In the Paste Special Dialog Box choose ADD.
  4. 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

NEW! I invite you to view a short video introduction to The Company Rocks Excels Blog

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • Technorati
  • e-mail

rss Subscribe to our RSS Feed

This entry was posted on Monday, July 21st, 2008 at 8:03 am and is filed under Functions, Tips and Time Savers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

« Name a cell and use it in a formula
Use Paste Special, Add to combine data from 2 columns »

One Response to “How to identify and convert text values to numbers”

  1. The Company Rocks » Blog Archive » I have been busy adding content to my new blog Says:
    July 22nd, 2008 at 12:00 pm

    [...] 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 [...]

Leave a Reply

You must be logged in to post a comment.