 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Negative numbers parentheses
Hi, I want to see negative numbers in parentheses in Excel 2000 SP3 and can't get it to work. Though regional settings show negative numbers like this (-1) it's not the case in excel. If I use a custom format it works but just for the current session. The newly defined format won't remain there for further Excel session. I also tried to modify the appropriate registry key according to KB240829 with no success. Is there a way to get this parentheses to show or it's a bug in Excel 2000? Thanks in advance. Steve Amirault Format > Cells... > Number > Custom > #,##0.00_);(#,##0.00) or something similar  SignatureGary''s Student - gsnu2007a > Hi, > [quoted text clipped - 9 lines] > > Steve Amirault Thanks for replying but please read the post again: If I use a custom format it works but just for the current session. The newly defined format won't remain there for further Excel session. I did try that like I mentionned it though I didn't specifed what was the format... Steve > Format > Cells... > Number > Custom > #,##0.00_);(#,##0.00) > [quoted text clipped - 15 lines] >> >> Steve Amirault You have to set it in Windows first: Start > Settings > Control Panel > Regional and Language Options > Customize > Numbers and then Currency > Select the number format that you want then you can select the Parentheses option in the Format > Cells > Number dialog box. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Thanks for replying but please read the post again: > [quoted text clipped - 27 lines] >>> >>> Steve Amirault Once again Thanks for replying but please read the post again: Though regional settings show negative numbers like this (-1) it's not the case in excel. Sorry if it wasn't clear enough but I did make sure that regional settings was set to use parentheses and it doesn't work! I tested on more than one PC, had (-1) and (-1$) selected and can't get it to work in Excel. Steve > You have to set it in Windows first: > [quoted text clipped - 37 lines] >>>> >>>> Steve Amirault Did you then select the required format in the format dialog box? SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Once again Thanks for replying but please read the post again: > [quoted text clipped - 50 lines] >>>>> >>>>> Steve Amirault Yes I did. I tried formatting the cell BEFORE typing in numbers and whether it's number or currency format, both won't show parentheses but this format: -1234,54 or -1234,54$ In the format dialogue box, negative numbers with parentheses is not available at all. I just don't understand. Regional settings is set to show them but it doesn't. According to the user who requested that type of format, Excel 97 did that with no problem and he wants to have the same result in Excel 2000 but only got live the above result. > Did you then select the required format in the format dialog box? > [quoted text clipped - 54 lines] >>>>>> >>>>>> Steve Amirault Try this there is a specific Part about XL2000: http://support.microsoft.com/kb/832285 SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Yes I did. I tried formatting the cell BEFORE typing in numbers and > whether it's number or currency format, both won't show parentheses but [quoted text clipped - 65 lines] >>>>>>> >>>>>>> Steve Amirault If I switch from Francais Canada to English US, parentheses are availables but the dollar sign is in front of the number which aren't the format here in Canada. Then I customized the dollar sign to show after the number and kept the English US and parentheses were available. So I have to set the Country to US and the dollar sign to show after the numbers and it works. Thanks Steve > Try this there is a specific Part about XL2000: > [quoted text clipped - 69 lines] >>>>>>>> >>>>>>>> Steve Amirault > If I switch from Francais Canada to English US, Ah yes but you will be losong 7 cents on the dollar! <g> Glad that you got it to work for you. SignatureReagdrs, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk Steve Note that in Regional Seettings you must make the stting change under the "Currency" setting, not just the "number". Gord Dibben MS Excel MVP >Yes I did. I tried formatting the cell BEFORE typing in numbers and whether >it's number or currency format, both won't show parentheses but this format: [quoted text clipped - 64 lines] >>>>>>> >>>>>>> Steve Amirault This is what I did. Steve > Steve > [quoted text clipped - 79 lines] >>>>>>>> >>>>>>>> Steve Amirault Excel picks this up from a windows setting: Windows start button|control panel regional and language options regional options tab click the customize button currency tab change the negative currency format to show ()'s. > Hi, > [quoted text clipped - 9 lines] > > Steve Amirault SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.