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

Select the sheet
Choose ToolsOptions
On the View tab, under Window options, remove the check mark from Formulas.
Click OK


et wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html