I am not sure about automatically but the way I use is
In a blank cell enter -1 copyhighlight range of numbers to convertpaste
specialmulitply
HTH

"MKLeisure" wrote:

One of our employees routinely enters a column of numbers that are all
negetive. Is there some way to have Excel automatically enter the negetive
sign?