Negative number formats change when multiple users share a spreadsheet, causing frustration

jkass

New Member
Joined
Sep 24, 2014
Messages
1
My entire Finance Department wants to show negative numbers with parentheses -- as (1), not as -1. I created a custom format that does this for me, and which aligns the decimal points. When other people in my department open a file that I created, they see the negative number as I want them to see -- as (1) -- but the actual Excel format for that cell changes. My custom format is lost when they open the file. If they save the file, and then I open it, the number format is once again changed, to something undesirable, -1. How can I fix this problem? Here are the specifics:

I am using Windows 7 and Excel version 2010. I have this problem with my coworkers who are using exactly the same software. I also have this problem with my coworkers who are using Windows 8 and Excel version 2013. I think that the source of the problem is some setting on my PC, but I have not been able to find such a setting. All of us have set our Microsoft Office defaults set to show negative numbers with parentheses. It appears that Excel is overriding these defaults.

Specifics:
I start with a custom format of #,##0_);(#,##0) . The number is displayed as (1).
When a coworker opens the file, they see a format of (1,234) . The number is displayed as (1).
When I open the file after a coworker has saved it, I see a format of #,##0;-#,##0 . The number is displayed as -1.

One curiosity I have noticed is that I do not have a format of (1,234) on my PC. Instead, I have a format of -1,234.

Can you offer any suggestions?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,122,962
Messages
5,599,065
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top