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

[Rose Emma]

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.
[TABLE="width: 80"]
<tbody>[TR]
[TD="width: 80, align: center"][/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

If you just want to enter text, either don't include the = sign, or use ="Emma" for example.

 

[Rose Emma]

But I need text with =text

 

[RoryA]

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]

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.

 

[Rose Emma]

But if i enter =any text this change to #NAME?

But i need text with =text

 

[RoryA]

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

 

[Rose Emma]

plz give suggestion

 

[Stiuart_W]

1) Change cell format to TEXT
2) Type this '=RoseEmma

 

[RoryA]

http://www.mrexcel.com/forum/excel-...ed-function-problem-plz-help.html#post3620224
or
http://www.mrexcel.com/forum/excel-...ed-function-problem-plz-help.html#post3620229