Negative numbers in parentheses in Excel 2010
aldo
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello,
Windows 7
Microsoft Office 2010
In Excel, how can we display negative numbers by putting them in parentheses?
For example: Type -4 and the display shows (4)
Thank you
Aldo
Configuration: Windows 7 / Internet Explorer 8.0
Windows 7
Microsoft Office 2010
In Excel, how can we display negative numbers by putting them in parentheses?
For example: Type -4 and the display shows (4)
Thank you
Aldo
Configuration: Windows 7 / Internet Explorer 8.0
3 answers
Hello
we can't see the question very well, there. If it's to put negative numbers in parentheses in a series of positive or negative numbers, you need to use conditional formatting and the formatting option is only available since Excel 2007:
Conditional formatting by formula:
select the field to be processed
Ribbon / Home / Conditional Formatting / New Rule
use this formula:
=Cell<=0
cell being the address of the 1st cell at the top left of the field
Format / Number / Custom
type:
;(0);
you will have the positive numbers in standard format and the 0 and the negatives in parentheses without the - sign
best regards
we can't see the question very well, there. If it's to put negative numbers in parentheses in a series of positive or negative numbers, you need to use conditional formatting and the formatting option is only available since Excel 2007:
Conditional formatting by formula:
select the field to be processed
Ribbon / Home / Conditional Formatting / New Rule
use this formula:
=Cell<=0
cell being the address of the 1st cell at the top left of the field
Format / Number / Custom
type:
;(0);
you will have the positive numbers in standard format and the 0 and the negatives in parentheses without the - sign
best regards