| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatically put negative sign in cells with positive numeric dat
I have many cells with positive numeric content that I need to change to
negative numbers without changing the absolute value of the numbers. Is there a way to highlight a block of cells and have a negative sign inserted in all of them? It will take me forever to do this manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
| How can I automatically change the font color of text in cells th. | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
| Can i automatically format cells to be a certain color if the val. | Excel Worksheet Functions | |||
Threaded Mode
