Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet with amounts. When I import them in a program they go
in as opposite value. Such as the positive 35 goes in the program as -35 and -35 goes in as 35. I have over 300 lines, and would like to reverse the signs make the negative positive and positive negative. Can this be done? Would like answer tonight if possible. Thanks to any one in advance that can solve this. I am sure it is a simple worksheet functions I have tried some even insert symbol which works but I can only do 1 cell at a time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change a large number of cells from a postive to a neget. | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |