On the toolbar menu:

FormatFormatCellNumber and choose (1234.56) from the list.

HTH

"Alex" wrote:

The only option I could choose from format is to show negative numbers with
"-" in front but I want to show negative number in brackets.