date displays as serial number

[Guest]

I'm using Office 2003. I inherited a workbook where one sheet insists on
displaying all dates as serial numbers. I format the cells to display a
date, but still get the serial number, left justified. The other sheets
behave as expected, following the cell format. Any ideas?

 

[CLR]

Try putting a 1 in an unused cell, then copy it and paste-special-multiply
on the column of errant dates
Hopefully this will turn them back into numbers which can then be formatted
as dates.............

Vaya con Dios,
Chuck, CABGx3

 

[Debra Dalgleish]

That sheet may be set to display formulas. To change the setting:

Select the sheet
Choose Tools>Options