Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why does Excel display 01/12/2005 as 38364 when the cell value is.
Excel 2000 and 2003 displays 01/12/2005 as 38364 even though the cell value
is 01/12/2005. How do I change this? If it matters, this is a shared workbook stored on a network drive. |
#2
|
|||
|
|||
XL stores dates as integral offsets from a base date. 01/12/2005 happens
to be 38,364 days after 12/31/1899. To see the date format again, choose Format/Cell/Date... In article , "Chris" wrote: Excel 2000 and 2003 displays 01/12/2005 as 38364 even though the cell value is 01/12/2005. How do I change this? If it matters, this is a shared workbook stored on a network drive. |
#3
|
|||
|
|||
Try changing the cell format to Date.
-- Regards; Rob ------------------------------------------------------------------------ "Chris" wrote in message ... Excel 2000 and 2003 displays 01/12/2005 as 38364 even though the cell value is 01/12/2005. How do I change this? If it matters, this is a shared workbook stored on a network drive. |
#4
|
|||
|
|||
JE McGimpsey wrote...
XL stores dates as integral offsets from a base date. 01/12/2005 happens to be 38,364 days after 12/31/1899. .... Extra picky: 12-Jan-2005 is (38,364 - 61) days after 1-Mar-1900, giving full disclosure of the false leap year bug. |
#5
|
|||
|
|||
In article .com,
"Harlan Grove" wrote: Extra picky: 12-Jan-2005 is (38,364 - 61) days after 1-Mar-1900, giving full disclosure of the false leap year bug. OK... 38364 "Excel days" <g |
#6
|
|||
|
|||
Maybe you're viewing formulas:
Tools|options|View Tab|uncheck formulas. Chris wrote: Excel 2000 and 2003 displays 01/12/2005 as 38364 even though the cell value is 01/12/2005. How do I change this? If it matters, this is a shared workbook stored on a network drive. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do I display a hyperlink in a seperate cell in excel? | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
Display a pix from a URL in a Excel cell | Excel Discussion (Misc queries) |