View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default formating individual cells

Try this:

(A1+B1)*-1


"piper" wrote:

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!