Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can i put a negative sign on a range of selected cells?
I would like to know is there a way to help putting a negative sign on
the selected cells. Actually I have to transform the +numbers filled in the cells into a negative numbers by simply putting a negative sign in front. Right now i am so stupid by amend each cell whereas i have at least 50 cells to change, so I wonder is there a way can speed up these kind of data entry process?? |
#2
|
|||
|
|||
One way. put -1 in an empty cell, select that cell, copy it, select the 50
cells you want to convert, do editpaste special and select multiply -- Regards, Peo Sjoblom (No private emails please) "chermaine" wrote in message oups.com... I would like to know is there a way to help putting a negative sign on the selected cells. Actually I have to transform the +numbers filled in the cells into a negative numbers by simply putting a negative sign in front. Right now i am so stupid by amend each cell whereas i have at least 50 cells to change, so I wonder is there a way can speed up these kind of data entry process?? |
#3
|
|||
|
|||
Put your data requiring a negative into columm "B"
Into another column you've created (lets say column "A") place a minus sign. Place this into column C: =A1&B1 Copy down all of column C, and you've got negative numbers. If you need to replace column B, copy, and paste as values all the data in column C, to wherever you like, back to column B, you may delete column A. Pierre |
#4
|
|||
|
|||
Hi!
Did you try this? You can't enter a minus sign into a cell without entering it as TEXT: '- When you concatenate A1 and B1 you end up with a TEXT string and not a negative number. This will work: =(A1&B1)*1 But Peo's suggestion is the best way to accomplish this. Biff "Pierre" wrote in message oups.com... Put your data requiring a negative into columm "B" Into another column you've created (lets say column "A") place a minus sign. Place this into column C: =A1&B1 Copy down all of column C, and you've got negative numbers. If you need to replace column B, copy, and paste as values all the data in column C, to wherever you like, back to column B, you may delete column A. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |