| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
change cell from negative to positive
I am trying to change the polarity of a cell with a signal funtion, i.e.
change a negative number to a positive and visa versa. I have a spreadsheet which I have imported from an accounting software and I need the numbers which are positive to be negative and numbers which are negative to be positive. I know that I can multiply the cell by a -1 but I have more than 1700 cells to do this to. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
| background color of my cell does not change | Excel Discussion (Misc queries) | |||
Threaded Mode
