Forum Discussion
Solved
Converting a large spreadsheet to a table and formula results change
I have a large spreadsheet of data and I have converted it to a table (re-engineering old file layouts). When I do the conversion, the results of existing formulas change and I'm stumped as to why. ...
If you converted the range to the table and in row 3 are headers of the table, with conversion to table they were converted to the texts. In formula you shall convert them back to number with double dash or VALUE(). And better to use structured references here.
Thank you SergeiBaklan - that worked perfectly !!!
Jo1963 , you are welcome, glad to help