when pressing the enter key after formating a cell in excel 2003 file, a
window message will say "to many different cell format". If I press OK, and
later save the file, the other previous formatting will be gone once I opened
the same file.

hi
excel 03 allows 4000 different format combinations. this has been increased
to 64000 for 07.

see this site for more details and possible fixes.
http://support.microsoft.com/default...b;en-us;213904

regards
FSt1

"edwin_dammam" wrote:

when pressing the enter key after formating a cell in excel 2003 file, a
window message will say "to many different cell format". If I press OK, and
later save the file, the other previous formatting will be gone once I opened
the same file.

You have too many cell formats.

See this KB Article for explanation and fixes.

http://support.microsoft.com/default...b;en-us;213904


Gord Dibben MS Excel MVP

On Mon, 8 Mar 2010 14:05:01 -0800, edwin_dammam
wrote:

when pressing the enter key after formating a cell in excel 2003 file, a
window message will say "to many different cell format". If I press OK, and
later save the file, the other previous formatting will be gone once I opened
the same file.