Excel 2013 problem

Posted on 2014-07-18
Last Modified: 2014-07-18

Very strange behavior of Excel 2013

At least 2 visible problems in the same worksheet (only in the worksheet, other worksheets are fine)

C2 = 2
If I insert a formula in D2 like "=C2", it display "=C2" and not 2
It displays the formula instead of the result of the formula
An also if a Copy/Paste D2 to D3, D4 D5, Ect...the copy do not work and =C2 is displayed all the time

In Option, advanced Options, the "display formula content instead..." in checked OK

In a blank new worksheet I do not have this problem. It seems related to this specific worksheet only

Any Idea

Thank you
Question by:gadsad
    LVL 8

    Accepted Solution

    Select Problem Area - Right Click Format Cells - Select - General

    LVL 6

    Expert Comment


    Is D2 formatted as Text?


    Author Closing Comment

    thank you it works!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now