great...this file was converted from MSWORKS...ergo, same problem

"Jeff Stevens" wrote:

> 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" <FLKULCHAR@discussions.microsoft.com> wrote in message
> news:7E29C628-3B7E-45F3-B84F-9D7FDFE0D37D@microsoft.com...
> > 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
>
>
>