date displays as serial number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
That sheet may be set to display formulas. To change the setting:

Select the sheet
Choose Tools>Options
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

generate serial numbers and date it entered 3
Date Format as *3/14/2008 9
Auto display all related info 2
Excell 2003 format cells 1
The Serial # is showing and not the actual date 2
Worksheet Combobox 1
Pasting "as displayed" formatted cell contents 6
Date to TEXT. NOT to sequential serial number 2

Back
Top