smurphy123

Posts: n/a

Excel Default date for date format

Everytime I enter a date in a cell, Excel thinks it is 2001. How to I get
the default date to think it is 2005?

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
In Excel, how can you format for 4 digit years (MM/DD/YYYY)?	Chucky	Excel Discussion (Misc queries)	4	January 19th 05 10:47 PM
Format an excel column as a date for a 5 day week for a year.	dabenesch	Excel Discussion (Misc queries)	1	December 30th 04 02:45 PM
USING THE DATE FORMAT IN EXCEL	teach	Excel Discussion (Misc queries)	3	December 14th 04 11:55 PM
Problem with Date format from VBA code	twig	Excel Discussion (Misc queries)	3	December 7th 04 06:01 PM

All times are GMT +1. The time now is 08:49 AM.

About Us

"It's about Microsoft Excel"