View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
david[_3_] david[_3_] is offline
external usenet poster
 
Posts: 2
Default display problem with brackets

have got some cells with brackets around numbers.

format is "("General")"

cell A1 contains 4 which displays as (4)

cell A2 = 5 which displays as (5)

but it goes wrong when I calculate...

cell A3 = A1 - A2 which displays as -(1)

but I want it to display as (-1)

how do I get the minus sign inside the brackets?

thanks