Why does Excel display 01/12/2005 as 38364 when the cell value is.

Dave Peterson

Posts: n/a

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
how do I display a hyperlink in a seperate cell in excel?	Jose	Excel Discussion (Misc queries)	1	January 12th 05 12:42 AM
display negative values as a blank cell in Excel	pherozeb	Excel Discussion (Misc queries)	3	January 5th 05 04:40 AM
display negative values as a blank cell in Excel	Pheroze Bharucha	Excel Discussion (Misc queries)	0	January 4th 05 10:51 PM
Display a pix from a URL in a Excel cell	Pilot007	Excel Discussion (Misc queries)	1	December 27th 04 12:22 AM

All times are GMT +1. The time now is 08:22 PM.

Menu

About Us