| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how can a range of Pos #'s be changed to negative num
I dulicate a large series of cells that are all positive. Is there a
shortcut to change them to all negaive? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how can a range of Pos #'s be changed to negative num
Hi,
Type -1 in a cell, copy that and then select the range, which has the positive numbers which you want to convert to negative. Right click on the range, select paste special, and choose action as 'Muliply'. Regards Govind. Stuart Millner wrote: I dulicate a large series of cells that are all positive. Is there a shortcut to change them to all negaive? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how can a range of Pos #'s be changed to negative nu
Perfect, thanks a million, what an easy solution....
"Govind" wrote: Hi, Type -1 in a cell, copy that and then select the range, which has the positive numbers which you want to convert to negative. Right click on the range, select paste special, and choose action as 'Muliply'. Regards Govind. Stuart Millner wrote: I dulicate a large series of cells that are all positive. Is there a shortcut to change them to all negaive? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
| Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
