The simple answer is to reduce the number of cells formats. Standardize the
formatting throughout the workbook to a few of the common ones. If there
are many differenct currency formats use a header to indicate the currency
and set number formatting to one of the more usual ones.
No easy task if the workbook is large, but a sheet by sheet simplification
is the only way.
