LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
snixflowergirl
 
Posts: n/a
Default Dates in 2005 format cells are not entering correctly.

Since 2005, using format cells, then date, I normally enter any date, for
example 123004 enter and the date 12/30/04 is displayed. Now beginning this
week, when I enter 123004 enter, 10/8/2236 is displayed. I can, however,
physically type the slashes 12/30/04 and the date will enter as typed. This
problem just began Monday after the beginning of the new year, so, I believe
it somehow is a date problem with the software.
 
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
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 11:57 AM
I am not able to format cells for zip codes JMelloman Excel Worksheet Functions 3 December 14th 04 02:24 AM
Any way to force European format dates in sheets? neil f New Users to Excel 6 December 12th 04 09:52 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM
When I select "format cells", the format dialog box does not disp. Andy S. Excel Worksheet Functions 2 November 23rd 04 03:49 AM


All times are GMT +1. The time now is 04:23 AM.

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"