String to numbers How to convert text to number in Excel: Even though you will have values in your spreadsheet that resemble numbers, they may not actually be numbers. This conversion is important ...

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

When you try to graph the values in the column, you can't graph them because Excel thinks they are strings, not numbers. To make a graph with strings in Excel, convert the strings to numbers and ...

However, when I go to reformat them, Excel -insists- on converting the number to scientific notation--and since I'm editing the string into a non-number format (multiple spaces, parenthesis, etc ...