Excel Calculated Function Problem........ Plz help...........

Rose Emma

New Member
Joined
Oct 31, 2013
Messages
4
When I inter this text any column and row this is convert =Zeyran to #NAME?

If i also write =Emma this is convert to #NAME?

Any =text change to #NAME?

I don't want this change plz help me how to disable this system in excel column.

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,391
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If you just want to enter text, either don't include the = sign, or use ="Emma" for example.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,391
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If that's what you need to appear in the cell you can:
1. Format the cell as Text and then enter =text, or
2. Enter '=text, or
3. Enter ="=text"

2 is probably simplest. :)
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,203
Office Version
2010
Platform
Windows

ADVERTISEMENT

But I need text with =text
Then change the Cell Format to Text before you enter that text into the cell. Alternately, you can type an apostrophe character first, then type your text... so, you entry would be '=text the apostrophe will not show up in the cell's display.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,391
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS

ADVERTISEMENT

You have three suggestions to fix that. Please try one or all of them.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,318
Messages
5,510,561
Members
408,800
Latest member
Realexcel

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top