Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reverse sign?
Excel 2007
I have a column of numbers, all negative. Like: -213.00 -4,521.78 I want to change them to positive. Not sure how to do this. Thanks, GC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reverse sign?
Try this:
Enter -1 in an empty cell Copy that cell Select the range that you want to convert Then: Paste SpecialMultiplyOK Delete the -1 -- Biff Microsoft Excel MVP "Chips" wrote in message ... Excel 2007 I have a column of numbers, all negative. Like: -213.00 -4,521.78 I want to change them to positive. Not sure how to do this. Thanks, GC |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reverse sign?
multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past special/values
and place results were you need them. ?? "Chips" wrote in message ... Excel 2007 I have a column of numbers, all negative. Like: -213.00 -4,521.78 I want to change them to positive. Not sure how to do this. Thanks, GC |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reverse sign?
multiply by -1 did the trick.
Thanks, Greg "Meebers" wrote in message ... multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past special/values and place results were you need them. ?? "Chips" wrote in message ... Excel 2007 I have a column of numbers, all negative. Like: -213.00 -4,521.78 I want to change them to positive. Not sure how to do this. Thanks, GC |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reverse sign?
Glad that worked for you in spite of all my "typo's" (was on the phone
during my response.) "Chips" wrote in message ... multiply by -1 did the trick. Thanks, Greg "Meebers" wrote in message ... multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past special/values and place results were you need them. ?? "Chips" wrote in message ... Excel 2007 I have a column of numbers, all negative. Like: -213.00 -4,521.78 I want to change them to positive. Not sure how to do this. Thanks, GC |
#6
|
|||
|
|||
A fairly quick fix is to highlight the column of negative numbers; go to the Home tab and click on Find & Select drop down. Click on Replace. On the Replace tab, Find what: box put in a negative sign and in the Replace with: box hit the space bar once. Then you can replace one at a time or replace all the negatives in the column by clicking on Replace All.
|
#7
|
|||
|
|||
Quote:
If your negative number is in A2, put =ABS(A2) in a blank column and copy down. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
Reverse Sign of A Column of Numbers | Excel Discussion (Misc queries) | |||
Function to reverse the sign of a cell | Excel Worksheet Functions | |||
Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
Reverse the sign of a number in a cell | Excel Worksheet Functions |