Either by formula:

=-A1

or using paste special:
Type -1 in a cell, copy the cell, select the range, use Paste Special,
Operation Multiplication, to multiply the range by -1.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jlojones821" wrote in message
...
Is it possible to have a series of cells automatically add the negative
sign
in front of an inputed number?