| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : Convert Positive Numbers to Negative Numbers ?
Dear Sir,
May I know is there any short cut to convert a large block of positive number to negative number or vise versa without having to put a negative sign at each cell for the the entire block (either manually or copying) ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : Convert Positive Numbers to Negative Numbers ?
Put -1 somewhere in the spreadsheet. Copy it, then select the range of cells
you want to change the sign on, paste special, multiply and click OK. This changes positive values to negative values and negative values to positive values. Dave -- Brevity is the soul of wit. "Mr. Low" wrote: Dear Sir, May I know is there any short cut to convert a large block of positive number to negative number or vise versa without having to put a negative sign at each cell for the the entire block (either manually or copying) ? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : Convert Positive Numbers to Negative Numbers ?
It works.
Thanks Dave Low -- A36B58K641 "Dave F" wrote: Put -1 somewhere in the spreadsheet. Copy it, then select the range of cells you want to change the sign on, paste special, multiply and click OK. This changes positive values to negative values and negative values to positive values. Dave -- Brevity is the soul of wit. "Mr. Low" wrote: Dear Sir, May I know is there any short cut to convert a large block of positive number to negative number or vise versa without having to put a negative sign at each cell for the the entire block (either manually or copying) ? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| How do I replace negative numbers with zero in Excel. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
