ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NEGATIVE IN BARCKETS AND UK DATES (https://www.excelbanter.com/excel-discussion-misc-queries/33407-negative-barckets-uk-dates.html)

EASTCOAST

NEGATIVE IN BARCKETS AND UK DATES
 
DOES ANYBODY KNOW HOW I CAN SET THE SYSTEM SO THAT WE CAN GET NEGATIVE
NUMBERS IN BRACKETS AND THE DATE FORMAT IN ENGLISH AT THE SAME TIME

Hank Scorpio

On Fri, 1 Jul 2005 02:33:02 -0700, EASTCOAST
wrote:

DOES ANYBODY KNOW HOW I CAN SET THE SYSTEM SO THAT WE CAN GET NEGATIVE
NUMBERS IN BRACKETS AND THE DATE FORMAT IN ENGLISH AT THE SAME TIME


(For Windows XP; use a similar path with other versions)

Go to the Start menu - Control Panel - Regional and Language
Options. On the Regional Options tab, select the appropriate locale.

To get the brackets, you'll probably have to click on the Customize...
button and change the negative number format for Numbers and / or
Currency.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Dave Peterson

These are windows settings, so for each pc that needs it...

Windows start button|settings|control panel|regional settings
(Or regional and language settings in winXP)

Regional Options tab, customize button in winxp

Currency Tab
change the negative currency format to show ()'s.

And on the Date tab, use a mm/dd/yyyy (or what you like) as the short format.

EASTCOAST wrote:

DOES ANYBODY KNOW HOW I CAN SET THE SYSTEM SO THAT WE CAN GET NEGATIVE
NUMBERS IN BRACKETS AND THE DATE FORMAT IN ENGLISH AT THE SAME TIME


--

Dave Peterson


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com