missing red brackets for formatting
 

When excel was first installed, I could format for negative numbers or
currency and choose red brackets now that option is gone - yes I know I can
create custom formats to conpensate for the loss.

Someone told me after installing the program Costpoint this also happend to
them.
I have check the regional setting for windows but it doesn't fix my problem.

Does anyone have any idea how to fix this without uninstalling this program

Any suggestions appriciated
Thanks Chris

missing red brackets for formatting
 

It is the regional settings. I don't know what you checked, but this
controls that capability.


--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
When excel was first installed, I could format for negative numbers or
currency and choose red brackets now that option is gone - yes I know I
can create custom formats to conpensate for the loss.

Someone told me after installing the program Costpoint this also happend
to them.
I have check the regional setting for windows but it doesn't fix my
problem.

Does anyone have any idea how to fix this without uninstalling this
program

Any suggestions appriciated
Thanks Chris

missing red brackets for formatting
 

Chris

When changing Regional Settings make sure you select the parens under the
"Currency" tab, not under the "Number" tab.


Gord Dibben MS Excel MVP

On Sun, 27 Aug 2006 14:18:55 -0400, "Chris" wrote:

When excel was first installed, I could format for negative numbers or
currency and choose red brackets now that option is gone - yes I know I can
create custom formats to conpensate for the loss.

Someone told me after installing the program Costpoint this also happend to
them.
I have check the regional setting for windows but it doesn't fix my problem.

Does anyone have any idea how to fix this without uninstalling this program

Any suggestions appriciated
Thanks Chris

missing red brackets for formatting
 

That did it I only changed the Number tab before
changing the currency tab fixed my problem
Thanks much


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chris

When changing Regional Settings make sure you select the parens under the
"Currency" tab, not under the "Number" tab.


Gord Dibben MS Excel MVP

On Sun, 27 Aug 2006 14:18:55 -0400, "Chris" wrote:

When excel was first installed, I could format for negative numbers or
currency and choose red brackets now that option is gone - yes I know I
can
create custom formats to conpensate for the loss.

Someone told me after installing the program Costpoint this also happend
to
them.
I have check the regional setting for windows but it doesn't fix my
problem.

Does anyone have any idea how to fix this without uninstalling this
program

Any suggestions appriciated
Thanks Chris

missing red brackets for formatting
 

Changing the format under the Currency Tab of Regional Settings is not really
intuitive so gets missed most of the time.


Gord

On Thu, 31 Aug 2006 17:42:33 -0400, "Chris" wrote:

That did it I only changed the Number tab before
changing the currency tab fixed my problem
Thanks much


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Chris

When changing Regional Settings make sure you select the parens under the
"Currency" tab, not under the "Number" tab.


Gord Dibben MS Excel MVP

On Sun, 27 Aug 2006 14:18:55 -0400, "Chris" wrote:

When excel was first installed, I could format for negative numbers or
currency and choose red brackets now that option is gone - yes I know I
can
create custom formats to conpensate for the loss.

Someone told me after installing the program Costpoint this also happend
to
them.
I have check the regional setting for windows but it doesn't fix my
problem.

Does anyone have any idea how to fix this without uninstalling this
program

Any suggestions appriciated
Thanks Chris




Gord Dibben MS Excel MVP