One way
In a blank cell enter -1 copy highlight range with numbers needing
correction Editpaste special and click the radio button for multiply
HTH

"pooperdoodle" wrote:

i am having to enter negative numbers in a single column. is there a way to
do so without having to enter all of them one by one manually? is there a
command that will automatically make my entry negative?