View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default display problem with brackets

Try this:

(General);(-General)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"david" wrote in message
...
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