| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
simple query changing set of numbers from positive to negative
have a string of numbers in a column that are positive and would like to
make negative ie 1384.40 128.31 193.7 .... and would like to make place minus in front ie -1384.40 -128.31 -193.7 .... Appreciate advice Sammy |
|
#2
|
|||
|
|||
|
Put -1 in an empty cell, copy it, select the numbers and do editpaste
special and select multiply -- Regards, Peo Sjoblom "sammy" wrote in message ... have a string of numbers in a column that are positive and would like to make negative ie 1384.40 128.31 193.7 ... and would like to make place minus in front ie -1384.40 -128.31 -193.7 ... Appreciate advice Sammy |
|
#3
|
|||
|
|||
|
thanks for advice
"Peo Sjoblom" wrote in message ... Put -1 in an empty cell, copy it, select the numbers and do editpaste special and select multiply -- Regards, Peo Sjoblom "sammy" wrote in message ... have a string of numbers in a column that are positive and would like to make negative ie 1384.40 128.31 193.7 ... and would like to make place minus in front ie -1384.40 -128.31 -193.7 ... Appreciate advice Sammy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| Numbers aren't changing with new format why? | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
Hybrid Mode
