Permanant Symbol

[billinr]

I have a cell in which I use the ± symbol, but occasionally change the value
associated with that tolerance.
Is there a way to keep the symbol in the cell, even when I change the text?
I am trying to avoid clicking within the cell and selecting the position for
the new text. I just want to enter text like it is a blank cell.

Appreciate any help!

 

[Bernard Liengme]

How about a custom format something like: "± "0.00
best wishes

 

[billinr]

This works for the format, but the symbol does not always show in the cell.
Our users are used to seeing the symbol, then editing the text which comes
after.
I am trying to speed up the editing process by allowing them to just click
and enter.
This works great for the final result, but I want the symbol to show even if
there isn't any text entered.

Got anything else?

Thanks