Anyway ignore excel error about + or = or - sign that written at first cell

[Unexpc]

Hi guys
anyway ignore or terminate this error and write + or - at first cell as a text?

 

[ClaireS]

Put ' (apostrophe) in front of your + or -.

 

[Unexpc]

Put ' (apostrophe) in front of your + or -.

yes i knew, without any character can doing this?

 

[ClaireS]

Actually, I can just type a + or - and it comes up as text anyway. Is this all you have in the cell? Are you trying to type "+/-"? That brings up the formula error. But it's OK if you format the cell as text.

 

[Unexpc]

Actually, I can just type a + or - and it comes up as text anyway. Is this all you have in the cell? Are you trying to type "+/-"? That brings up the formula error. But it's OK if you format the cell as text.

You are right, i change format cell to text and no problem or any errors, thank you

 

[ClaireS]

Happy to help

 

[Unexpc]

Happy to help

please see this: Wrong alignment when edit a cell on not English language