In many cases Microsoft Excel is smart enough to convert numerical strings imported from other programs to numbers automatically. A common reason for this is numbers formatted as text. Sometimes values in your Excel worksheets look like numbers, but they don't add up, don't multiply and produce errors in formulas. The tutorial shows many different ways to turn a string into a number in Excel: Convert to Number error checking option, formulas, mathematic operations, Paste Special, and more.