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é