| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks.
Done. ctdak "Gord Dibben" wrote: Enter -1 in an empty cell. Copy that cell. Select your positives and Paste SpecialMultiplyOKEsc Gord Dibben Excel MVP On Thu, 23 Jun 2005 17:42:02 -0700, "ctdak" wrote: 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
