microsoft XL

My version of microsoft office XP (microsoft XL) does not 
contain the option of showing negative numbers in 
brackets. The format/number command only allows a minus 
sign or negative numbers in brackets.
Am I missing some other command?
0
anonymous (74722)
11/29/2003 10:00:06 PM
excel.misc 78881 articles. 5 followers. Follow

7 Replies
1824 Views

Similar Articles

[PageSpeed] 13

Am I missing something in your post?

First you say

"does not contain the option of showing [negative numbers in brackets]"

then you say

"The format/number command only allows a minus sign or [negative numbers in
brackets]."

regardless the format looks like this

0.00_);(0.00)

or do you mean

0.00_);(-0.00)


-- 

Regards,

Peo Sjoblom

"keith rolfe" <anonymous@discussions.microsoft.com> wrote in message
news:026a01c3b6c4$260a4b80$a101280a@phx.gbl...
> My version of microsoft office XP (microsoft XL) does not
> contain the option of showing negative numbers in
> brackets. The format/number command only allows a minus
> sign or negative numbers in brackets.
> Am I missing some other command?


0
terre081 (3244)
11/29/2003 11:02:12 PM
>-----Original Message-----
>My version of microsoft office XP (microsoft XL) does not 
>contain the option of showing negative numbers in 
>brackets. The format/number command only allows a minus 
>sign or negative numbers in brackets.
>Am I missing some other command?
>.
>
0
anonymous (74722)
11/30/2003 3:16:36 AM
>-----Original Message-----
>Am I missing something in your post?
>
>First you say
>
>"does not contain the option of showing [negative numbers 
in brackets]"
>
>then you say
>
>"The format/number command only allows a minus sign or 
[negative numbers in
>brackets]."
>
>regardless the format looks like this
>
>0.00_);(0.00)
>
>or do you mean
>
>0.00_);(-0.00)
>
>
>-- 
>
>Regards,
>
>Peo Sjoblom
>
>"keith rolfe" <anonymous@discussions.microsoft.com> wrote 
in message
>news:026a01c3b6c4$260a4b80$a101280a@phx.gbl...
>> My version of microsoft office XP (microsoft XL) does 
not
>> contain the option of showing negative numbers in
>> brackets. The format/number command only allows a minus
>> sign or negative numbers in brackets.
>> Am I missing some other command?
>
>
>.Sorry - I meant negative numbers in RED
>
0
anonymous (74722)
11/30/2003 3:24:04 AM
How do I get brackets around my negative numbers?
0
anonymous (74722)
1/11/2004 7:56:08 PM
0.00_);(0.00)

General;(General)

-- 

Regards,

Peo Sjoblom

"willy" <anonymous@discussions.microsoft.com> wrote in message
news:C58C76EC-4DD1-4CEC-8C0F-1EE5AD0A7964@microsoft.com...
> How do I get brackets around my negative numbers?


0
terre081 (3244)
1/11/2004 8:01:49 PM
Hi Willy,

enter a user defined format (goto 'Format - Cells'). e.g. enter
0,00_ ,(-0,00 )

Frank

willy wrote:
> How do I get brackets around my negative numbers?


0
frank.kabel (11126)
1/11/2004 8:08:11 PM
sorry, typo:
 0,00_ ;(-0,00 )


0
frank.kabel (11126)
1/11/2004 8:36:00 PM
Reply:

Similar Artilces:

Mail Merge into Microsoft Word using Microsoft Access as data sour
On my computer I have no trouble using Microsoft Access queries as my data source for simple mail merge letters or mailing lists in Word. Using the mail merge wizard I select the data source which my computer shows as All Data Sources (*odc; *mdb; *mde; and so on). I select it and then select my Access database and Word shows me whatever query I selected as my data source or as Word puts it "receipients". However, on my partners computer, using the mail merge wizard, we select the data source which on her computer shows All Data Sources - but not the list of all types of da...

Microsoft Templates
When I attempt to download a Excel template from Microsoft's template area, I receive the following error: Excel.exe has generated errors and will be closed by windows. An error log has been created. Excel starts to open, and then closes. Where is the log, and what setting do I need to change to get the document to open? Thanks John I also encounter the same...see if this helps... ************************************************************* Dave Peterson Guest Posts: n/a Re: "Excel.exe has generated Errorsand neesd to close" -----------------------------------...

Microsoft Dynamics GP and Aust Tax Office SBR
Hi, Does anyone know if GP is going to be updated, to meet the new Australian Taxation Office) ATO Standard Business Reporting (SBR)? -- Geoff James This is a problem not only for Australians but also for us in UK. We are also required to file all tax returns and related Financial Statements in XBRL format and there aren't any generic softwares that can convert Word, Excel or any other formats into XBRL formats. I would have expected Microsoft to take a leading role into this but it seems it is pre-occupied fighting anti-trust cases all over the world and so decided to ...

Microsoft Word 07 Macro problem
I just re-installed the Microsoft Word 2007, but when I open a Word document, it pops up this. " The command cannot be performed because a dialog box is open, Click OK, and then close open dialog boxes to continue." Then I click OK, the dialog box shows " The document contains macros. Macro language support for this application is disabled. Features requiring VBA are not available. Would you like to open this document read-only?" And the Help is.... "This error usually occurs because of macro security settings. If you know that the macro comes from a sour...

Task 'Microsoft Exchange Server' reported error (0x8004010F) : 'The operation failed. An object could not be found.' #2
Hi, I have been running Outlook 2003 through HTTP over RPC to connect to an Exchange 2003 server for some time without troubles until recently. All of the sudden both I and my users have been getting the following error on send / receive: "Task 'Microsoft Exchange Server' reported error (0x8004010F) : 'The operation failed. An object could not be found.'" I have tried rebuilding the offline address list and creating new profiles. We are able to send and receive mail without issue. But I am worried that this error is indicative of a problem i am not seeing and it...

Microsoft.public.commercial
So, I see that this newsgroup is no longer listed in the community. What happened to that bad boy? TPTB determine it was a dead one? -- Brian Kvalheim From the volume of questions regarding commercial printing of Publisher files I guess so. Maybe if they, TPTB, fixed GDI it wouldn't be so much of a problem. Matt Beals Consultant Enfocus Certified Trainer Markzware Recognized Trainer (425) 582-8554 - Office (206) 201-2320 - Voicemail (206) 618-2537 - Mobile mailto:matt@mattbeals.com Come visit me at: http://www.automatetheworkflow.com http://www.mattbeals.com http://blog.mattbeals.com ...

"Cash balance" in Microsoft Money 2004/2005
Somehow I must have changed some setting in Money that is causing this problem. It started with Money 2004. I hoped it would go away when I updated to Money 2005, but it didn't. The problem is that in a brokerage account when I sell a stock the "Cash balance" value doesn't get updated. "Cash balance" doesn't get updated when I add cash to the account either. Can anyone point me to the setting I might have changed to cause this? Thanks for your help! Hello, You wrote on Fri, 15 Apr 2005 05:19:06 -0700: M> Somehow I must have changed some setting i...

Can you forward multiple email addresses to the same queue in Microsoft CRM 3.0?
I currently have my CRM queue setup properly. However, I was wondering, if I have a queue called support@test.com, i seem to only be able to process email in the queue if the email is addressed to "support@test.com". If i want to use another forwarding address such as "support-client@test.com" forwards to support@test.com the email doesn't get processed into the queue. I noticed that the only difference is that in the "to" box, the address is actually support-client@test.com since the message was forwarded or this address is a distribution list and this seems...

Tools/References/Microsoft Word 10.0 Object Library vs 11.0
Hello, (I can go a year without asking a question, then it seems like I'm asking questions weekly... sorry!) Anyway, I wrote an additional feature for a client which works perfectly for me and for all the people/machines in one of my client's departments, but not the other. It gathers a few separate Word documents and combines them into one Word document - all within the a form's code in Access. The only difference is that in the department where is doesn't work, they have Office XP, and the department it does work in has Office 2003. We believe we've narrowed i...

FW: Try on pack from the Microsoft
--kwsrspakhislfdazv Content-Type: multipart/related; boundary="bhjrnlda"; type="multipart/alternative" --bhjrnlda Content-Type: multipart/alternative; boundary="qqymcijzbcauwrq" --qqymcijzbcauwrq Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to maintain the security of your computer from these...

HOT Reqs : Microsoft Business Solutions | 12+ Months | Chicago, IL (Functional and technical)
HOT Reqs : Microsoft Business Solutions | 12+ Months | Chicago, IL (Functional and technical) ---------------------------------------------------------------------------------------------------------------------------------------------- Microsoft Business Solutions (Microsoft Small Business Financials) Need one resource each for Functional and Technical roles. Location : Chicago, IL Duration : 12+ Months Funtional : This person will be responsible for the requirements gathering and setting up the system. Technical : This person will be responsible for installing and maintaining th...

Microsoft Office Specialist Certification-useful or not?
:confused: I am thinking about getting the Microsoft Office Specialis certification and wonder whether it's useful or not. If you think it' worth a try, could you please give me some suggestion on which vendor' preperation product to use? Thanks a lot -- Message posted from http://www.ExcelForum.com ...

upgrade to microsoft office 2007
What is the last expensive route to upgrade from Microsft Office '03 to '07? I guess that would depend on the version you are using and the version you want to use. Check out http://office.microsoft.com/en-us/products/FX101754511033.aspx You might want to wait for Office 2010, out June 15 if I'm not mistaken (retail). Yves "Jenny" <Jenny@discussions.microsoft.com> wrote in message news:FD4F46FF-8993-4A46-B29C-237C5AE55667@microsoft.com... > What is the last expensive route to upgrade from Microsft Office '03 to > '07? If you...

Microsoft Outlook 2003 on Vista
After installing Microsoft Outlook 2003 on our new computer with Vista processor, we receive several emails that produce 20 20 and html language. It pulls up fine on a windows 2000 and Windows XP that we have. We only have problems on the machine that has Vista. Can't read it. Do you have any clues as to what changes we need to make in order to be able to read those emails properly. eu falo portugu�s..... yo ablo espa�ol I'm answer a english "texas" <allcorn@theallcorns.com> escreveu na mensagem news:42445a61-a1cf-4612-a030-a3f435ce8e72@v3g2000hsc.googlegroups.com......

Every time I open Microsoft Excel or Word my system crashes. Can.
...

Thanks Microsoft For Money 2004 Deluxe
Microsoft (If The Money 2004 Team Actually Reads These Posts), I am so extremely pleased with this product and just wanted to say THANKS for creating it. Most posts are problems and complaints but damn few to none are compliments. This is a compliment. Thanks For A Superior Product (Which Quicken 2004 Isn't)! BTJustice I agree, I've been using this product since Money 99 and am very pleased. - Jeff "Buford T. Justice" <???@msn.com> wrote in message news:c244fn$1onot5$1@ID-208839.news.uni-berlin.de... > Microsoft (If The Money 2004 Team Actually Reads These ...

Can CRM Mobile 1.2 work with Microsoft CRM 3.0 Latest Release??
I want to upgrade CRM 1.2 to 3.0 but my question is I can still use CRM mobile 1.2 with new 3.0 release or not. Please suggest. Unfortunately Not. The CRM 3.0 Client for Windows Mobile is not due for release until 90-days after General Availability. Regards, Simon "SP" <SP@discussions.microsoft.com> wrote in message news:EAE5F823-6045-429A-944E-560B2AB39F89@microsoft.com... >I want to upgrade CRM 1.2 to 3.0 but my question is I can still use CRM > mobile 1.2 with new 3.0 release or not. Please suggest. There is no information the crm 3 mobile client. For inst...

Microsoft Outlook & Windows NT
I tried to open Microsoft Outlook but I couldn't. The system send me a message that a dll file is missing. Where can I find and download the entire application. I would prefer to reinstall all the program Version of Outlook, what dll-file is mentioned in the error? Outlook isn't available as a download just on CD. You can contact Microsoft if you need a replacement set. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed with Service Pack 3 ----- "Bayardo Velasquez" <velasquezruiz@y...

Microsoft Money 2003 File Menu
I have old Money files that I no longer need.I deleted these files but the file names still appear at the bottom of the Money File Menu.Is there some way to remove the file names from the File Menu? Thank you; In microsoft.public.money, RobJ wrote: >I have old Money files that I no longer need.I deleted >these files but the file names still appear at the bottom >of the Money File Menu.Is there some way to remove the >file names from the File Menu? You could open some other files so they become the most recently used. Or you could searc...

Microsoft Dynamics CRM 3.0 Implementing
MS CRM Security,Integration with Microsoft Dynamics GP 9.0/IBM Lotus Notes Domino... http://microsoft-crm-3.blogspot.com ...

switching investment charts in microsoft money plus deluxe
I'm using Microsoft Money Plus Deluxe 17.0 As in Money 2004 clicking on a listed investment on the Home tab goes directly to a price chart. In the earlier program I could switch quickly between investment charts using a drop down list on the chart page. In money plus deluxe 17.0 I have to go back to Home first or the Portfolio tab. Can I make this work as before? Thanks for any help. "Dave K" <p_sellars-at-hotmail-dot-com> wrote in message news:eqMaGmEcIHA.4712@TK2MSFTNGP05.phx.gbl... > > I'm using Microsoft Money Plus Deluxe 17.0 > > As...

How to save an Excel spreadsheet as a Microsoft Works Spreadsheet file
I have a project that I have created in Excel but need to open it in Microsoft Works. Is there a way to do that? If so how? I don't own works, but if you do, you can do a File|open and see what file formats it accepts. I think it'll open early versions of both excel and Lotus 123. But I'm not sure what early really means. If you don't own works, give a call to the person you need to share and ask them to do file|open in works, while you do a file|saveAs in Excel. You should see at least one common file format. Shelly wrote: > > I have a project that I have crea...

Can I use "Print Shop" files in Microsoft Publisher?
How to Compose a Good Newsgroup Post http://dts-l.org/goodpost.htm How to Act Smart on Usenet http://www.catb.org/~esr/faqs/smart-questions.html Getting Your Post Noticed - and Answered http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp How Not to Get Help in Newsgroups http://users.tpg.com.au/bzyhjr/liszt.html Otherwise, you might as well try here: Psychic Friends Network (800) 592-7827 But, to answer your question, no of course not! It's proprietary - and why should MS consider supporting files from a small company such as Broderbund is?! Copy and paste may work...

Microsoft outlook #24
I am running windows XP and for about a month now Microsoft outlook is very unstable. when opening up the message "unable to start processing services" appears and when I click OK it closes outlook. I have to do this a few times before it will function satisfactorily. as messages start coming it in freezes at about 20% complete. HAVE YOU TRIED: HELP, DETECT & REPAIR "glynda" <gsumhome@bigpond.net.au> wrote in message news:02d401c42441$26b66ba0$a601280a@phx.gbl... > I am running windows XP and for about a month now > Microsoft outlook is ver...

RESOLUTION to Microsoft Money Has Stopped Working Issue
I tried the below, uncheck the box that says Run this program in compatability mode for: It was a success! Thank you Gary! GarDavis wrote: > > Properties also showed it was using WinXP compatability mode so I > unchecked that and tried again. > > It worked on the sample and also on my networked mny file. > > Help->About showed version 1415. > > All is well again:) > > Gary Davis Where is the box located that you uncheck? "The Big Woo" wrote: > I tried the below, uncheck the box that says Run this program in > compatability...