Forum Home
Press F1
Thread ID: 7760	2001-02-14 03:23:00	Negative values in brackets	Guest (0)	Press F1

Post ID	Timestamp	Content	User
8708	2001-02-14 03:23:00	I have Windows 98 SE & SR1 installed on a Toshiba Tecra 8100 along with Office 2000. I want to show negative values in Access and Excel in brackets. The local settings under Windows have been adjusted to show this. Unfortunately the bracket negative format does not appear in the Excel format cells control. All applicable sections of Windows and Office seem to be installed OK and everything else works correctly. I would appreciate assistance in getting this to work correctly.	Guest (0)
8709	2001-02-14 04:08:00	In Excel you need use Format Cells Custom. The following entry will show negative numbers in red text in brackets, if you don't want red text, remove the [Red] from the custom entry. #,##0.00;[Red](##0.00) HTH	Guest (0)
8710	2001-02-14 04:18:00	Thanks for the reply, Russell. This is one solution which works in Excel but unfortunately is not directly available in Access as it picks up on the settings from 'Local settings' in Windows. I've set this up but does not seem to feed through. On other machines set up seemingly identically then in Excel the format cells command shows an example of say a number in red and brackets under numbers.	Guest (0)
8711	2001-02-14 09:12:00	Have you already tried control panel, regional settings, currency, and change to brackets ? Ian	Guest (0)
1