Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates Being Entered as 06/27 have equal sign added (Excel 2000)

    Hi,

    A very strange situation has just cropped up. Yesterday, a spreadsheet I was working on worked fine. I enter a date in a column as 6/27 and I get a date. Today, Excel insists on prepending an equal sign to all date entries and thus calculating them as a mathematical formula. So, when I enter 6/27 today, I get 0.222222. The strange thing is that this column is still formatted to display dates as "m/dd/yyyy". What suddenly happened to cause this? Yesterday it worked fine, today it's broken!!!

    Please HELP! I have reviewed formatting, conditional formatting, validation, etc. etc.

    Thanks!!

    Drew

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dates Being Entered as 06/27 have equal sign added (Excel 2000)

    Select Tools | Options...
    Activate the Transition tab.
    Clear the check boxes on this tab, then click OK.
    You should be back to normal now.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates Being Entered as 06/27 have equal sign added (Excel 2000)

    Hans!

    You've got to be kidding! That was it?!?!?! WOW! THANKS!!! I still have no idea why that would have suddenly become enabled, but removing the check boxes definitely fixed the problem!

    Thanks again, <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Drew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •