Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
display problem with brackets
This seems to work:
"("General")";"("-General")" -- Biff Microsoft Excel MVP "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
display problem with brackets
Hi,
If all of your numbers are whole number you could use (0);(-0) or (#);(-#) And then to display more decimal you simple click the Increase Decimals button on the toolbar. -- If this helps, please click the Yes button Cheers, Shane Devenshire "david" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
display problem with brackets
Many thanks to everyone who replied. All your ideas worked!
"T. Valko" wrote in message ... This seems to work: "("General")";"("-General")" -- Biff Microsoft Excel MVP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
display problem with brackets
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "david" wrote in message ... Many thanks to everyone who replied. All your ideas worked! "T. Valko" wrote in message ... This seems to work: "("General")";"("-General")" -- Biff Microsoft Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Number Display -- need Brackets | Excel Discussion (Misc queries) | |||
display problem.... | Excel Discussion (Misc queries) | |||
Problem with date display | Excel Worksheet Functions | |||
I seem unable to display negative values with brackets | Excel Discussion (Misc queries) | |||
New Display Problem | Excel Worksheet Functions |