Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date displays as serial number
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? |
#2
|
|||
|
|||
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 "et" wrote in message ... 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? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert Date serial number to date | Excel Worksheet Functions | |||
How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
& reference answering as Date Serial # not actual text | Excel Worksheet Functions |