Spreadsheet Compare - use original number format when exporting results
The Spreadsheet Compare tool included in Excel 2013 and the Inquire add-in has the ability to export the results of a comparison to a new spreadsheet in a handy tabular format.
However the "Old Value" and "New Value" columns are formatted as text. If the number format in the spreadsheets being compared was "number, one decimal place", the Spreadsheet Compare output looks like this:
This makes it difficult to compare Old Value and New Value using formulae because one first has to strip out the value between parentheses and convert to number.
My suggestion is to output the value without any formatting (21.990702621768023) or keep the value with the original formatting (21.990702621768023 formatted as 22.0).