Format Cells

[Guest]

From a previous spreadsheet which i have returned to (.xls type) I cannot
change the date formats via right clicking the cell or going to the
Format...Cells...Number route. Why? What shall I do?

 

[Dave Peterson]

The only time I've seen this is when the original workbook was created in a
different program--crystal reports or Lotus 123.

I included a few "sacrificial" cells in my selection, made my changes to all of
them.

Then went back and fixed the sacrificial cells to the way they were supposed to
be. (Try a cell way out of the way of where the data really is.)