Using brackets to display negative values

[gordclark]

Using brackets to display negative values

[dosydos]

are you asking how to format a number to show a negative number using ()?
if so select the cell of column or rows you want to be formatted and then select the numbers format dialog box on the Home ribbon right below the decrease decimal button. You can then choose number or currency and you will see it gives you an option of how you want to display negative numbers as well as symbols or decimal places. choose what you like and select ok.

[newdoverman]

Select the cells that you want to format.
Right click in the selection and choose Format Cells
Click on Custom and enter in the Type box ###;(###) if you don't need the , separator for thousands
enter #,###;(#,###) if you need the comma separator.

[protonLeah]

Brackets "[]" are not parentheses "()"

Brackets: custom format with: #,##0_);"["#,##0"]"

[FDibbins]

Brackets "[]" are not parentheses "()"

Brackets: custom format with: #,##0_);"["#,##0"]"

Ben, that all depends on where you come from. In the USA, that is the case, but I am English/South African, and we never called them parenthesis (unless we wanted to be fancy) - we called then square brackets [], curly brackets {} or just brackets ()

[protonLeah]

USA:
brackets []
braces {}
paren..()

so, Canada

[newdoverman]

@protonLeah
You have it the way it is used in Canada at least as far as I know. Some definitions of terms are different between the U.S.A. and Canada, who uses the British system officially but for the most part we are the same.