On the toolbar menu:

Format>FormatCell>Number 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.