+ Reply to Thread
Results 1 to 4 of 4

Excel Auto Inserting Single Quote In All Cells

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,444

    Excel Auto Inserting Single Quote In All Cells

    I recently experienced a catastrophic crash of my computer. After reloading an image file of my hard drive, Excel has been
    automatically inserting a single quotation mark ( ' ) before all text and symbols. If numbers are included with text the same
    occurs ... in there are ONLY numbers in the cell ... no insertion of single quote.

    I've looked through as many Excel settings as I could find. Nothing was found related to this issue.

    Do you have an answer how to get rid of these insertions ?


    Thank you.



    This Is What The User Sees In The Cells ...

    Correct time
    2 Mins
    3 Mins
    15 Mins


    This Is What You See In The Formula Bar ...

    'Correct time
    '2 Mins
    '3 Mins
    '15 Mins

  2. #2
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Excel Auto Inserting Single Quote In All Cells

    Hi, try this:

    Click File, then select Options. Under Excel Options, click Advanced. Scroll down, then uncheck Transition navigation keys under Lotus compatibility.

    keys.JPG
    Last edited by Dante Amor; 06-07-2022 at 07:29 PM.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,444

    Re: Excel Auto Inserting Single Quote In All Cells

    Genius .... sheer genius !

    I never would have guessed.

    Thank you Dante !

  4. #4
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Excel Auto Inserting Single Quote In All Cells

    I'm glad to help you. Thanks for the feedback.

+ 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. Replies: 1
    Last Post: 03-14-2016, 09:28 AM
  2. Replies: 7
    Last Post: 11-22-2015, 05:48 PM
  3. [SOLVED] How to find and replace hidden single quote ? (This sign is single quote: ')
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2014, 03:48 PM
  4. Excel automatically adds a single quote ( ' ) to cells
    By servalsoft in forum Excel General
    Replies: 5
    Last Post: 09-12-2011, 03:22 PM
  5. Need to remove leading single quote from text cells
    By katcar in forum Excel General
    Replies: 4
    Last Post: 10-09-2009, 04:48 PM
  6. Replies: 3
    Last Post: 01-21-2006, 11:45 PM
  7. How can I get rid of the ' single quote in Excel Worksheet
    By Ivan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2005, 02:05 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