| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Permanant Symbol
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Permanant Symbol
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Permanant Symbol
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
| Permanant button for macro | Excel Worksheet Functions | |||
| How can we back up a permanant copy of an excel file automaticaly | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
| I have a permanant footer. I have deleted it several times but i. | Excel Worksheet Functions | |||
Hybrid Mode
