I have downloaded a Quickbooks file, which has changed everything into text.
The formula only displays the formula and doesn't calculate the values. I
have tried formatting the cells (used in the formula, as well as the formula
itself), and they show $0 if I format to a numerical value. I have tried to
copy the column into a different workbook and paste as values only, but still
nothing.
Does anyone have any suggestions?