I have had similar problems with formatting when I use a file that was
converted from Lotus to Excel. Other than that, I'm stumped as well.


"FLKULCHAR" wrote in message
...
This is interesting:

I wish to apply one of the auto-formats to my selection of cells, and...

IT DOES NOT WORK; I select the range of cells, properly select
auto-format, etc.

HOWEVER, IF I GO TO A BLANK WORKBOOK, THEN SELECT A GROUP OF BLANK
CELLS...APPLY THE AUTO FORMAT...IT WORKS...

THEN, I "COPY AND PASTE SPECIAL" (formatting only) INTO THE ORIGINAL
WORKSHEET, AND IT WORKS!!

Please help!

I do not wish to copy and paste special.

FLKulchar