I have received a spreadsheet that contains data that looks like numbers but my formulas will not work because they show the data to be text. I have spent hours attempting to convert the data to a number but to no avail. I am attaching the file because I believe that will be the easiest way to solve the problem.
I have placed formulas in the sheet that confirm the data is text, yet when I try to convert the data to a number, (format change, edit/paste special, value(), etc.) the data will not change format and thus I cannot complete my formulas. I have simplified my formulas to hopefuly help in solving this. TextNumber.xlsx