One way to do this is by adding a column with formulas that refer to
the column in which you enter numbers. For instance if you enter data
in A1, the formula in B1 might be something like
=ABS(A1)*-1

This takes the absolute value of A1 and multiplies by -1, returning a
negative number. The absolute value is in there just in case you enter
a negative number.