[Top 50 Excel Problems] No. 7: Numbers won't calculate! Converting 'text numbers' to numeric values

If you enter numbers but the sum is 0, or the sort order is strange, check if the numbers in the cells are saved as 'text' ...
Hosted on MSN

Double dash: The secret to smarter Excel formulas

Unlock the power of the double dash feature in Excel! This video explores how it can fix broken formulas, convert text to numbers, and perform calculations that you might not think are possible in ...