Excel Formula That Won't List Results After Reformatting

Sometimes when you have a complex formula entered in a column in Excel, even after the format is changed from Text to General, the correct results won't be given unless you click in each cell. If you're faced with this problem, try selecting the column and pressing F9. The formulas should automatically update.