Lets say you enter all the numbers in your column as positive (without the -
sign). Then enter -1 in an unused cell somewhere. Copy this cell and paste
it special into all your positive numbers with the multiply option checked.

This will make all your numbers negative in one fell swoop.
--
Gary's Student


"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?