+ Reply to Thread
Results 1 to 3 of 3

Unable to escape error (started cell with plus sign)

  1. #1
    Registered User
    Join Date
    10-14-2016
    Location
    Atlanta
    MS-Off Ver
    MS Office for Mac 15
    Posts
    1

    Unable to escape error (started cell with plus sign)

    Hello -

    I was working on a budgeting worksheet and typed +/- into a cell (not for a formula). After hitting enter I get the following error message
    "The formula you typed contains an error. To get assistance in entering a function, click OK, then click Function on the insert menu. If you are not trying to enter a formula, avoid using an equal sign or a minus sign, and proceed it with a single quotation mark"

    My problem is that I can't escape the error message to delete the +/-. When I hit OK, the error message comes right back so I have no option to edit the cell.

    How can I escape the error message? I'm hoping I don't have to "Force Quit" Excel - I'll lose 2 hours worth of data.

    Thanks in advance.

    (My version is MS Office for Mac 15.26)

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Unable to escape error (started cell with plus sign)

    Hi,

    I'm afraid I can't assist with saving your work but I can tell you that I cannot reproduce the problem in the latest build 15.28
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: Unable to escape error (started cell with plus sign)

    Precede it with a single Quote '+/-

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Unable to hide rows containing dash sign
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2016, 05:27 AM
  2. escape causes error
    By DJams in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 06:20 PM
  3. Return focus and escape from cell?
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2011, 11:31 AM
  4. Compile error has suddenly started happening
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2007, 11:38 AM
  5. error on escape key from popup
    By arunvj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2006, 07:23 AM
  6. [SOLVED] Error suddenly started occuring
    By Richard in forum Excel General
    Replies: 1
    Last Post: 07-14-2006, 07:40 PM
  7. [SOLVED] Error 13 on many trim with cells started with +
    By pcouas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2005, 09:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1