LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Dates not entered correctly

Hi

I have Excel 2003 (11.8220.8221) SP3 running on Vista Ultimate SP1 and have
a weird glitch.

Whenever I try to enter a date such as todays date, Oct 4, into Excel - it
inputs it as Oct 1, 2004. It takes my day input as a year... How do I fix it
so it returns to normal and output the proper month/day instead of
month/year.

I have never seen this issue before in any previous version of Excel.

Any help would be appreciated as it is starting to get anoying entering the
year everytime.

Thanks,
 
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
dates not appearing correctly in XL 2007 One Stone Charts and Charting in Excel 2 October 6th 07 03:06 PM
Email address entered correctly lv Excel Discussion (Misc queries) 0 June 20th 07 07:06 PM
How do I sort dates that are not formatted correctly? curious1 Excel Discussion (Misc queries) 7 November 1st 06 10:14 PM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 04:00 AM
Formula Result isn't entered correctly in worksheet Formula Results Show Incorrectly New Users to Excel 1 October 22nd 05 10:29 PM


All times are GMT +1. The time now is 02:16 AM.

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

About Us

"It's about Microsoft Excel"