| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing positive values to negative
Im using excel 2007with windows xp pro. I use excel very infreuently and
not since upgrading to 2007. I have a long column of dollar values that I need to change from positive to negative values such as: $123.45 ($123.45) I can accomplish the feat manually over many hours by F2.HOME- ENTER DOWN ARROW and repeat and repeat and repeat. Or I can use a macro. But using a macro has changed from years ago. When I tried the macro inserted a specific value of cell rather than the value of the selected cell. So that didnt work. What can make this conversion easier? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a cell color to reflect positive or negative total | New Users to Excel | |||
| Changing formuals from Positive to negative | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| Changing Positive to Negative | Excel Worksheet Functions | |||
| simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) | |||
Threaded Mode
