Why your numbers will add cell by cell, but won't sum! How to convert unconvertable text to numbers.
If you have ever tried to sum a column, but get zeros - this is for you!!! Its happened to you a ton of times. Don't re-key the numbers and format as numbers with the format tools!!! All you have to do is use text to columns!
#excel #hiddenexceltricks #exceltutorial #spreadsheethelp