| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
In a blank cell type: -1 Now copy that cell Now highlight the range of cells containing your numbers that you want to make negative Right click on any cell within that highlighted range Choose Paste Special and check Multiply (in the Operation area) Click OK -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=401217 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i convert number to wording | Excel Discussion (Misc queries) | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| Return number of cells filled | New Users to Excel | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
Threaded Mode
