To many different cell formats
 

I'm receiving an error message "To many different call formats" in my
workbook. How do I resolve this? Thanks.

See:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

HTH
Jason
Atlanta, Ga

-----Original Message-----
I'm receiving an error message "To many different call
formats" in my
workbook. How do I resolve this? Thanks.
.

Hi Joe,

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.

Regards

Paul






"Joe" wrote in message
...
I'm receiving an error message "To many different call formats" in my
workbook. How do I resolve this? Thanks.