Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default HELP - Excel Date defaults to 2001

I have installed Excel 2003 and the Date feature keeps defaulting to the year
2001. This means I have to type dates out in full instead of MMM DD and
having the YYYY filled in automatically (like it used to for me).
Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default HELP - Excel Date defaults to 2001

Are you sure that the system date as set in the control panel is not 2001?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kim" wrote in message
...
I have installed Excel 2003 and the Date feature keeps defaulting to the

year
2001. This means I have to type dates out in full instead of MMM DD and
having the YYYY filled in automatically (like it used to for me).
Thanks,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel date format trouble michaelberrier Excel Discussion (Misc queries) 2 April 21st 06 05:21 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel formula with date constraints Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 03:08 PM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"