No but having entered some numbers in a range you can:
1 type -1 in some empty cell
2 copy the -1 with the Copy tool
3 select the range of numbers to be treated; use Edit | Paste Special and
specify multiply
Now all the positive numbers become negative and the negative ones become
positive
You can now delete the -1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"JoJoColorado" wrote in message
...
I am creating a spreadsheet form where a cell will always be a negative
number. Can I make the cell always negative without having to enter a
minus
sign each time?