|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 22nd, 2005, 04:23 PM
|
|||
|
|||
-ve number in brackets?
Office 2000 - XP PRO
I recently switched my Excel to a new computer. On the old comp in Number Format, there was a choice for -ve numbers to have brackets around the number. Now all I see is 4 choices - 2 having - preceding in black & 2 have - preceding in red. This was NOT a custom format but was shown under Number. Please advise. TIA 
|
|
#2
February 22nd, 2005, 06:25 PM
|
|||
|
|||
|
Doug
If bracketed negatives are not available in FormatCellsNumber..... This is a function of your Regional Settings in Windows OS. StartSettingsControl PanelRegional and Language SettingsRegional OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow and select the ($1.1) Apply and OKApply your way out. You will have to close Excel then re-open to see effects. You will then be able to choose that format. Gord Dibben Excel MVP On Tue, 22 Feb 2005 11:23:26 -0500, Doug Boufford wrote: Office 2000 - XP PRO I recently switched my Excel to a new computer. On the old comp in Number Format, there was a choice for -ve numbers to have brackets around the number. Now all I see is 4 choices - 2 having - preceding in black & 2 have - preceding in red. This was NOT a custom format but was shown under Number. Please advise. TIA
|
|
#3
February 22nd, 2005, 08:57 PM
|
|||
|
|||
|
Gord
I had tried that (twice) before posting but it didn't work. After your post, I went back in & after 3 tries it now works fine. (Guess I wasn't holding my tongue correctly)  Thanks for your help Doug Gord Dibben wrote: Doug If bracketed negatives are not available in FormatCellsNumber..... This is a function of your Regional Settings in Windows OS. StartSettingsControl PanelRegional and Language SettingsRegional OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow and select the ($1.1) Apply and OKApply your way out. You will have to close Excel then re-open to see effects. You will then be able to choose that format. Gord Dibben Excel MVP On Tue, 22 Feb 2005 11:23:26 -0500, Doug Boufford wrote: Office 2000 - XP PRO I recently switched my Excel to a new computer. On the old comp in Number Format, there was a choice for -ve numbers to have brackets around the number. Now all I see is 4 choices - 2 having - preceding in black & 2 have - preceding in red. This was NOT a custom format but was shown under Number. Please advise. TIA
|
|
#4
February 22nd, 2005, 11:10 PM
|
|||
|
|||
|
Go figure!!
Happy you're fixed up anyway. Thanks for the feedback. Gord On Tue, 22 Feb 2005 15:57:32 -0500, Doug Boufford wrote: Gord I had tried that (twice) before posting but it didn't work. After your post, I went back in & after 3 tries it now works fine. (Guess I wasn't holding my tongue correctly) Thanks for your help Doug Gord Dibben wrote: Doug If bracketed negatives are not available in FormatCellsNumber..... This is a function of your Regional Settings in Windows OS. StartSettingsControl PanelRegional and Language SettingsRegional OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow and select the ($1.1) Apply and OKApply your way out. You will have to close Excel then re-open to see effects. You will then be able to choose that format. Gord Dibben Excel MVP On Tue, 22 Feb 2005 11:23:26 -0500, Doug Boufford wrote: Office 2000 - XP PRO I recently switched my Excel to a new computer. On the old comp in Number Format, there was a choice for -ve numbers to have brackets around the number. Now all I see is 4 choices - 2 having - preceding in black & 2 have - preceding in red. This was NOT a custom format but was shown under Number. Please advise. TIA
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I set-up automatic number generation in Excel? | General Discussion | 0 | November 16th, 2004 04:58 PM | |
| query a number stored as text | Lee | Running & Setting Up Queries | 19 | October 13th, 2004 04:10 AM |
| Number of Mondays in month | Michael Noblet | Setting Up & Running Reports | 3 | July 28th, 2004 10:41 PM |
| Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
| Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |
Linear Mode
