|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 24th 05, 03:11 PM
|
|||
|
|||
How do I convert numbers to the opposite sign?
I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel. 
|
| Ads |
|
#2
October 24th 05, 03:17 PM
|
|||
|
|||
|
How do I convert numbers to the opposite sign?
times it by -1
|
|
#3
October 24th 05, 03:19 PM
|
|||
|
|||
|
How do I convert numbers to the opposite sign?
Put -1 in an empty cell
edit|copy that cell select your range to fix Edit|paste special|check multiply. CindyatRWD wrote: > > I need to change all positive numbers in the spreadsheet to negative numbers, > and vice versa in Excel. -- Dave Peterson
|
|
#4
October 24th 05, 03:24 PM
|
|||
|
|||
|
How do I convert numbers to the opposite sign?
Type a '-1' in some random cell and copy it (ctrl+C). Then select the cells
you want to switch and Edit > Paste Special, select Values and Multiple and click OK. "CindyatRWD" wrote: > I need to change all positive numbers in the spreadsheet to negative numbers, > and vice versa in Excel.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert numbers to text | bellman | Excel Discussion (Misc queries) | 0 | October 4th 05 10:28 PM |
| Align $ sign next to numbers | Christina | Excel Discussion (Misc queries) | 5 | April 7th 05 07:21 PM |
| How do I sum hours in Excel and convert to decimal numbers? | Heinsohn | Excel Discussion (Misc queries) | 2 | March 5th 05 07:48 PM |
| Is there a formula to convert numbers to written text in Excel? | LZC | Excel Worksheet Functions | 3 | November 27th 04 08:10 PM |
| how do i convert numbers to words | MazenBy | Excel Worksheet Functions | 2 | November 16th 04 05:28 PM |
Linear Mode
