| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Underline Button Missing from Formatting Toolbar | New Users to Excel | |||
| Formatting negative currency - doesn't have brackets | Setting up and Configuration of Excel | |||
| colours missing in conditional formatting. | Excel Worksheet Functions | |||
| help with brackets | Excel Discussion (Misc queries) | |||
| On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
Linear Mode
