How to change default cell formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel not using regional settings 6
How do I align numbers in different cells when some are in bracke. 2
Displaying negatives with (brackets) 3
Lining up decimal points with negatives in brackets 2
Format Cell Number Options missing 5
conditional formating with text 5
format negative figs 4
Format text string 2

Back
Top