Re: Format Option Unavailable
- From: Gord Dibben <gorddibbATshawDOTca>
- Date: Fri, 07 Apr 2006 11:48:18 -0700
Joe
If negative brackets are not available in the Number>Negative Numbers dialog.
This is a function of your Regional Settings in Windows OS.
Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)
Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.
Apply and OK>Apply your way out.
Gord Dibben Excel MVP
On Thu, 6 Apr 2006 16:40:01 -0700, Joe in Irvine, CA <Joe in Irvine,
CA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
For some reason, when I try to format a cell with a negative number, the
option to display it in parenthesis is nowhere to be found. It used to be
located in Format, Cells, Numbers . . . I can not find that format in any of
the standard number formatting options.
I have not made any changes to my installation, etc.
Any ideas?
Gord Dibben MS Excel MVP
.
- Prev by Date: RE: edit text string in column B
- Next by Date: Re: How can I control the length of characters a code will return?
- Previous by thread: Re: Format Option Unavailable
- Next by thread: Re: How do I update price lists easily from a central source?
- Index(es):
Relevant Pages
|
