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

"Bernard Liengme" wrote:

How about a custom format something like: "± "0.00
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"billinr" wrote in message
...
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!