HOW DO I FIX A TO MANY FORMATE CONDITION

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rjottavi - 04 Sep 2004 15:41 GMT

when i try to change the formate of a cell i get "to many cell formates
displayed"

Reply to this Message

Frank Kabel - 04 Sep 2004 15:48 GMT

Hi
for dealing with too many cell formats have a look at the following KB
article
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

Signature

Regards
Frank Kabel
Frankfurt, Germany

> when i try to change the formate of a cell i get "to many cell
> formates displayed"

Reply to this Message

David McRitchie - 09 Sep 2004 05:15 GMT

Leo Heuser posted a macro 2001-05-06 in programming as a
major revision of his earlier macro in the eee007 article.
http://google.com/groups?selm=OxP9cgi1AHA.1572%40tkmsftngp02
The macro gets rid of unused formats.

Slow Response, Memory Problems, and Speeding up Excel
http://www.mvps.org/dmcritchie/excel/slowresp.htm#formats
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi
> for dealing with too many cell formats have a look at the following KB
[quoted text clipped - 3 lines]
> > when i try to change the formate of a cell i get "to many cell
> > formates displayed"

Reply to this Message