View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Can you make a cell always negative without entering a minus each

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?