Excel SUM wrong? Fix numbers stored as text with Text to Columns
You add up a column, the total looks too small, and you start re-adding the figures one by one to find the mistake. Often there is no arithmetic mistake at all. Some of the "numbers" are text, usually because they…