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.
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.