Yes, that is it.

Thanks.

George

"Peter T" wrote in message
...
This, maybe:

http://support.microsoft.com/?kbid=818082
Title: You cannot format data imported from Access 2002 to
Excel 2000 or to Excel 97

Regards,
Peter


-----Original Message-----
Peter,

That has not worked. The sheet is not protected and I
have now Unlocked all
cells on the sheet. I have discovered that if I select a
column and then
Right-click Format, then the Format window appears and
allows me to make
changes however if I select a range or individual cell
and Right-click
Format, then it still does not work (appear).

do you have any other ideas?

George

"Peter T" wrote in
message
...
Hi George,

The scenario you describe fits the combination of non
locked cells on a protected sheet (Tools Protection).

Regards,
Peter

-----Original Message-----
Using Office 2000

I am regularly sent files in Excel format which have
been
extported from database applications.

Everything seems normal except that when I right-click
a
cell and select Format - Nothing happens. No Format
menu opens. The same happens (i.e.
nothing) when I select Format_Cells from the format
menu.

However if I go to another workbook and format a cell
then it works as normal.

Also if I copy a format using the format painter in a
different workbook, and then paste the format to a cell
in the Problem workbook then the format changes.

Can anybody tell me how to sort this Format problem
out?

Thanks in advance.

George



.