Fix the numerical table column headings to General or Number Format
Hi. In the attached workbook, the first sheet has a formula that pulls values from the second sheet according to the set criteria through the INDEX MATCH functions. My problem is that when I converted the source data into a table, the formula returned error results. The column headings which are numbers were turned into text. I tried formatting the headings into numbers and general but still the errors remain. Typing an apostrophe before the number in the first sheet just so the errors would be eliminated is incorrect.
The temporary workaround is to exclude the column headings in the table but the data source looks ugly.
Any idea on how to straighten the column headings?
Thank you.
|