Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel automatically adds an = sign to all entries (97/2000)

    I have a client's spreadsheet that automatically adds an = sign and therefore calculates most entries. Values entered remain values, no =. Example: Type in a date (4/11) and Excel gives you .36 (formula bar reads =4/11) or if formatted for a date gives you 01/00/00 (formula bar reads =4/11). New sheets, added columns, all cells act this way. I have looked in macros, viewed the sheet code, formatting, options. Changing the cell formatting does no good. What did the designer do?

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel automatically adds an = sign to all entries (97/2000)

    Go to Tool/Options/Transition and uncheck "Transition Formula Entry"

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel automatically adds an = sign to all entries (97/2000)

    Yes, that did it, thank you.

Posting Permissions

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