Posted to microsoft.public.excel.misc

external usenet poster

Posts: 50

6/30/2008 date error?!

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime I
place the date 6/30/2008 into this row excel displays "1/0/1900". I tried to
recreate the problem on other tabs of the workbook, or in new workbooks and I
can't.

What in the world is going on here?

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 template for 2008-2009 Academ calendar yr (Microsoft Excel 2	babylonian007	Excel Discussion (Misc queries)	1	November 1st 07 05:26 PM
NCAA Basketball Bracket 2008	robert morris	Excel Discussion (Misc queries)	0	October 5th 07 03:11 PM
Update 2007 calendar to 2008	fluffy	Excel Discussion (Misc queries)	1	September 26th 07 07:28 PM
date error	hitesh via OfficeKB.com	Excel Discussion (Misc queries)	1	October 20th 06 02:34 PM
How to calculate number of month from 2008 in Excel?	Frank	Excel Discussion (Misc queries)	7	February 7th 06 02:29 PM

All times are GMT +1. The time now is 07:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us