How to Calculate with Text in Excel When Numbers are Stored as Text
When numbers are stored as text in Excel it makes it difficult to perform calculations. You'll know your number is stored as text because it's left justified (on the left edge of the cell). Numbers are always right-justified (along the right edge of the cell).
This video will show you how to quickly convert those numbers from text in a few a different ways. And how to perform calculations with text in Excel.