Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Los Angeles, California, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel question (Excel 2000)

    Workbook is saved in Excel 2000. Opened that workbook using Excel 2003. I noticed that 2003 treats every entry I make as a formula since it automatically adds an "=" sign. For example, the date entry of "02/28/2005" is entered as "=02/28/2005." If I delete the "=" sign, it comes back. Talked to our help desk, and they do not know the answer other than use the date value function or turn that date into a label by adding a single quote in front of the date. Is my workbook corrupted? Went to cell format and checked the format. The date formatting is not working. Thanks!

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

    Re: Excel question (Excel 2000)

    Open the workbook in Excel 2003.
    Activate a worksheet on which you have this problem.
    Select Tools | Options...
    Activate the Transition tab.
    Is "Transition formula entry" ticked?
    Clear all check boxes on this tab, then click OK.

    Note: Transition formula entry and Transition formula evaluation are worksheet-level settings, so if this is the cause of your problem, you will have to clear the check boxes for each worksheet.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel question (Excel 2000)

    Tools, Options, Transition, uncheck "Transition formula entry".
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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