Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch negative numbers to positive numbers in Excel ?
Need to switch positive numbers to negative numbers (or vice versa) in Excel
worksheet efficiently, anyone can help me here? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch negative numbers to positive numbers in Excel ?
Hi,
Copy the cells, select another column and Paste Special by selecting Subtract. Do the same function for vice versa too. Regards, Jaleel "amashmallow888" wrote: Need to switch positive numbers to negative numbers (or vice versa) in Excel worksheet efficiently, anyone can help me here? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch negative numbers to positive numbers in Excel ?
Hi
Enter -1 into some free cell and copy the cell. Select the range with numbers, you want to change. Select PasteSpecialMultiply Remove -1 entered at start. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "amashmallow888" wrote in message ... Need to switch positive numbers to negative numbers (or vice versa) in Excel worksheet efficiently, anyone can help me here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turning positive numbers to negative | Excel Discussion (Misc queries) | |||
negative numbers in parenthesis are not clear on excel printout? | Excel Discussion (Misc queries) | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
BRACKETED NEGATIVE NUMBERS IN EXCEL | New Users to Excel |