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
|
|||
|
|||
Microsoft Knowledge Base Article - 832285Microsoft Knowledge BaseArticle - 832285
Hi,
Using Excel XP under Win2KPro. Regional Settings French(Canada) (Francais(Canada) I want to use parentheses for negative numbers in the Currency format. I followed Microsoft Knowledge Base Article - 832285 «The negative number inside parenthesis format is not available in Excel for numbers or for currency» but parenthese are still unavailable for negative numbers in all formats. Any suggestions? Thanks Alain |
#2
|
|||
|
|||
Microsoft Knowledge Base Article - 832285Microsoft Knowledge Base Article - 832285
Hi Alain,
Pick the format that comes closest to what you want then look at the cell format with Format, cells, number (tab), Custom But I can provide the following specific number format. I have Excel 2000 like you but set to US Regional settings Under Currency I set up the format which would produce (-$3.00) in red which I can see the actual format in Custom $#,##0.00_);[Red]($#,##0.00) Which you can paste into Custom Number format --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Alain" wrote in message ... Hi, Using Excel XP under Win2KPro. Regional Settings French(Canada) (Francais(Canada) I want to use parentheses for negative numbers in the Currency format. I followed Microsoft Knowledge Base Article - 832285 «The negative number inside parenthesis format is not available in Excel for numbers or for currency» but parenthese are still unavailable for negative numbers in all formats. Any suggestions? Thanks Alain |
#3
|
|||
|
|||
Microsoft Knowledge Base Article - 832285Microsoft KnowledgeBase Article - 832285
Hi David,
Thanks for your suggestion. Problem is that this custom format is more difficult to «export»; when I send data to my partners, I would like to use a standard format. I saw in Microsoft Knowledge Base Article - 240829 «XL: Parentheses Not Displayed in Number and Currency Format» that code in My Computer\HKEY_CURRENT_USER\Control Panel\International\iNegCurr should be 4 for the required format: in my registry, it was 15, despite appropriate settings in Control Panel. After setting it to 4 (codes 0 to 10 are listed and explained in this KB article), problem was solved. Seems that Control Panel, Regional settings fails to update registry. BTW, what are codes 11 to 15 (or more) for? Have a good day. Alain David McRitchie a écrit: Hi Alain, Pick the format that comes closest to what you want then look at the cell format with Format, cells, number (tab), Custom But I can provide the following specific number format. I have Excel 2000 like you but set to US Regional settings Under Currency I set up the format which would produce (-$3.00) in red which I can see the actual format in Custom $#,##0.00_);[Red]($#,##0.00) Which you can paste into Custom Number format --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Alain" wrote in message ... Hi, Using Excel XP under Win2KPro. Regional Settings French(Canada) (Francais(Canada) I want to use parentheses for negative numbers in the Currency format. I followed Microsoft Knowledge Base Article - 832285 «The negative number inside parenthesis format is not available in Excel for numbers or for currency» but parenthese are still unavailable for negative numbers in all formats. Any suggestions? Thanks Alain |
#4
|
|||
|
|||
Microsoft Knowledge Base Article - 832285Microsoft Knowledge Base Article - 832285
Hi Alain,
Would have assumed the custom format $#,##0.00_);[Red]($#,##0.00) would go with the spreadsheet, but I guess it might not go out from the English with $ currency from my experience with dates. With dates the format goes with it unless it matches your regional settings in which case it is simply marks it as a date, and the format may lose the four digit date elsewhere, along with changing the order depending on what someone has in their Short Date in Regional date setting. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Alain" wrote in message ... Hi David, Thanks for your suggestion. Problem is that this custom format is more difficult to «export»; when I send data to my partners, I would like to use a standard format. I saw in Microsoft Knowledge Base Article - 240829 «XL: Parentheses Not Displayed in Number and Currency Format» that code in My Computer\HKEY_CURRENT_USER\Control Panel\International\iNegCurr should be 4 for the required format: in my registry, it was 15, despite appropriate settings in Control Panel. After setting it to 4 (codes 0 to 10 are listed and explained in this KB article), problem was solved. Seems that Control Panel, Regional settings fails to update registry. BTW, what are codes 11 to 15 (or more) for? Have a good day. Alain David McRitchie a écrit: Hi Alain, Pick the format that comes closest to what you want then look at the cell format with Format, cells, number (tab), Custom But I can provide the following specific number format. I have Excel 2000 like you but set to US Regional settings Under Currency I set up the format which would produce (-$3.00) in red which I can see the actual format in Custom $#,##0.00_);[Red]($#,##0.00) Which you can paste into Custom Number format --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Alain" wrote in message ... Hi, Using Excel XP under Win2KPro. Regional Settings French(Canada) (Francais(Canada) I want to use parentheses for negative numbers in the Currency format. I followed Microsoft Knowledge Base Article - 832285 «The negative number inside parenthesis format is not available in Excel for numbers or for currency» but parenthese are still unavailable for negative numbers in all formats. Any suggestions? Thanks Alain |
Thread Tools | |
Display Modes | |
|
|