View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default how to add ( and ) when using function sum

No you didn't, use custom formats like

(General)

or

(0.00)





--
Regards,

Peo Sjoblom



"Sulasno" wrote in message
...
guess I did not pose the correct question

I want the end result to be in brackets

=sum(xxxx) =(total)


"Don Guillett" wrote in message
...
=sum(1,2,3)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?