+ Reply to Thread
Results 1 to 4 of 4

Edit value name and not formula name

  1. #1
    Registered User
    Join Date
    11-06-2022
    Location
    Norway
    MS-Off Ver
    Office 2021
    Posts
    2

    Edit value name and not formula name

    Hello!
    I have this excel spreadsheet that is like a predictor for the upcoming world cup in Qatar.
    The problem I have is that when I translate the sheet to Norwegian the United States cell/formula translates wrongly into "Forente stater" While I wanted it to be "USA" which is correct in Norwegian. When I try to replace it afterwards, it struggles because i can only change the formula and not the cell value/name itself'

    I can't figure out how to fix it. Any ideas?

    Cheers
    Albert
    Attached Files Attached Files
    Last edited by ALbert.nitter; 11-06-2022 at 01:18 PM. Reason: Issue solved

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Edit value name and not formula name

    You can change the names on the hidden "T" sheet to what ever you need.

  3. #3
    Registered User
    Join Date
    11-06-2022
    Location
    Norway
    MS-Off Ver
    Office 2021
    Posts
    2

    Re: Edit value name and not formula name

    Thank you very much!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Edit value name and not formula name

    You're welcome & 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. Edit formula to remove #VALUE from INDEX SUMPRODUCT ROW formula result
    By JohnElliott in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2019, 03:05 PM
  2. Edit edit links macro to automate sheet selection
    By sds1126 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2015, 12:27 PM
  3. Replies: 2
    Last Post: 03-21-2014, 11:43 AM
  4. Replies: 0
    Last Post: 09-06-2008, 01:50 PM
  5. IF formula question:edit the fist half of the original formula
    By impress in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 08:35 PM
  6. [SOLVED] i edit a formula (excel) then it displays formula not answer
    By caiman in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 10:05 PM
  7. Why can't I edit my excel document? Edit buttons shaded.
    By Arl @ CBC in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

Tags for this Thread

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