How to change default cell formats

When I open a file, all negative values are shown with a - before them,
whilst my colleagues, when opening the same file, the negatives are shown in
brackets ie. ( ). How do I ensure that when I open the same file, my negative
numbers appear in brackets

This is a windows setting.

Close excel

Change that windows regional setting|currency tab|Negative currency format
to show ($1.1)

Open excel

You may have to reformat:
Format|Cells|number tab|Number
(adjust the decimal places and comma options)

Easty04 wrote:
>
> When I open a file, all negative values are shown with a - before them,
> whilst my colleagues, when opening the same file, the negatives are shown in
> brackets ie. ( ). How do I ensure that when I open the same file, my negative
> numbers appear in brackets

--

Dave Peterson