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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.