View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default formating individual cells

Assuming the two cells are in A1 and B1
enter in C1
=-A1-B1

Greetings from New Zealand
Bill K

"piper" wrote in message
...
Hi, I am trying to format individual cells to give me a negative answer,
can
this be done. Example: 2 + 2 = 4 I need to try and get the answer to
become
2 + 2 = -4 any help would be appreciated thanks in anticipation!