Mystery with Text formatted cell - Help

[Banosjo]

Hello,
I have a cell with Text format.
If I write "- TestTest." (with a dash at the beginning and a dot at the end) and press Enter, no problem.
If I select another cell, the address of this cell is written after the dot and the selected cell is surrounded by dashes like when you make a formula.
It's a problem if it starts with "-", "+" or "=".
I work with Excel 2010 and Excel 2013.
Do you know if there is a way to avoid this, without having to manually enter a " ' " at the beginning?
Although I would prefer to avoid the use of " ' ", I have tried to have a " ' " added automatically in Worksheet_Change and Worksheet_SelectionChange instances but it doesn't work
Thanks! José

[DocAElstein]

Hello José,
Welcome to ExcelFox

I have two ways that I overcome these sorts of problems. I leave the cell as standard format , not text format.
Then
Either
Leave a space, before writing
Or
Write what I want as a formula.

So for your example, in a cell with standard format I would write exactly either of these two texts, ( remember the first one has a space before the - )

 - TestTest. 

="- TestTest."

I don’t know if there are any other ways to achieve what you want. I expect there might be, but I don’t know about them. Possibly someone else might have an idea later

Alan