+ Reply to Thread
Results 1 to 7 of 7

Need help with formula not working only show the formula in cell

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    76

    Need help with formula not working only show the formula in cell

    Hi All
    Need some help with this sheet it is a info from a system but the formula dont work on this sheet. The problem is with the sheet or tha data.
    Please check B3
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Need help with formula not working only show the formula in cell

    format to general and reenter the formula
    Click just below left if it helps, Boo?ath?

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with formula not working only show the formula in cell

    All cells from A1 to B6 are formatted as Text. Select both columns, change the format to General and then select cell B3 and press F2 and Enter.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    05-28-2014
    Posts
    76

    Re: Need help with formula not working only show the formula in cell

    Thank you but on this sheet it dont work
    Attached Files Attached Files

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with formula not working only show the formula in cell

    You have the "Show formulas in cells instead of their calculated results" option ticked in the Excel Advanced options dialogue box.


    Regards, TMS
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-28-2014
    Posts
    76

    Re: Need help with formula not working only show the formula in cell

    HAHAHAHA thank you did not see it so use to it not working

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with formula not working only show the formula in cell

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Need to add to a working if formula to show negative
    By IreneADS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2014, 03:24 PM
  2. [SOLVED] Formula to show formula from another cell
    By rodgersmg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2014, 03:48 AM
  3. Replies: 1
    Last Post: 07-26-2012, 03:49 PM
  4. [SOLVED] Formula result will not show when formula is copied to another cell
    By nabraham00 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-06-2012, 01:03 PM
  5. Replies: 0
    Last Post: 09-04-2011, 09:14 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