Results 1 to 4 of 4

Thread: Cannot Edit Formula

  1. #1
    Seeker farhad's Avatar
    Join Date
    Jul 2018
    Posts
    17
    Articles
    0
    Excel Version
    2013

    Cannot Edit Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good Day

    I am trying to edit a formula in cell: F1 to Read (E6:E150). When I try editing for some reason it does want to change the formul
    I have attached the sheet
    Thanks
    Attached Files Attached Files

  2. #2
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    86
    Articles
    0
    Excel Version
    O365
    The cell format is text, change it to General & you should be ok.

  3. #3
    Seeker farhad's Avatar
    Join Date
    Jul 2018
    Posts
    17
    Articles
    0
    Excel Version
    2013
    HI FLuff

    Thanks a million. Worked

    Once again thanks

  4. #4
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    86
    Articles
    0
    Excel Version
    O365
    You're welcome & thanks for the feedback

Posting Permissions

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