The following method can be used after the fact to format the inputs.
Use GOTO (either F5 or Cntrl G or Edit, Go To), click on SPECIAL..., then select Constants and clear the boxes with Text, Logical and Errors, thus leaving only Numbers. Click OK. All the cells with numbers (presumably all...
Dear RGCook
The method explained by PMOVER works exactly as he describes. Don't be too single-minded about the LINEST function. It normally does LINEAR regression but it does POLYNOMINAL regression when invoked as an array function. It's all explained by PMOVER.
As an example, if you need a...
Links can also be contained in NAMES, or defined ranges, styles and sometimes even in deleted graphs, which the methods described above can not detect.
To find the offending links in NAMES, navigate Insert, Names, Define which then shows a window with defined names. Pick each name and see at...