I have a user currently using excel 2007 on Windows 7 who requires all the negative figures from hundreds of financial spreadsheets to be shown in brackets. As they do not have permission to access Control Panel I have logged onto the PC as the network administrator and changed the settings in Region and Language to show both numbers and currency with brackets. (This solution works for XP running office 2003)
When logging back on as the user for the first time it did work and all negative figures were shown in brackets. After a couple of hours this has now reverted back to display a '-' instead and the bracket option no longer appears under the 'Format Cells' menu. I have logged back onto the PC as the administrator and the negative bracket options are still selected in the Region and Language options under Control Panel. I have also installed the SP2 for office 2007 as well with no result.