Put % in ( )

Dear all,

Is it possible to format a cell to stay like it: ( -10% )?

With this format (0%), the excel shows this - (10%)

Thanks a lot!!!

Andr=E9.

0
gatarossi (81)
2/8/2008 8:22:48 PM
excel 39879 articles. 2 followers. Follow

2 Replies
757 Views

Similar Articles

[PageSpeed] 17

Try this Custom Number Format:
Select the cell(s) to be impacted

From the Excel Main Menu:
<format><cells><number tab>
Category: Custom
Type: (0%);(-0%);(0%)
Click [OK]

Those settings will display:
 10% as (10%)
-10% as (-10%)
  0% as (0%)


Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
<gatarossi@ig.com.br> wrote in message 
news:4188b0ad-a272-4558-b419-7bc7614fbe51@z17g2000hsg.googlegroups.com...
Dear all,

Is it possible to format a cell to stay like it: ( -10% )?

With this format (0%), the excel shows this - (10%)

Thanks a lot!!!

Andr´┐Ż.


0
2/8/2008 8:30:12 PM
Dear Ron, Thanks!!!!

Now it is ok!!!!

Andr=E9.
0
gatarossi (81)
2/8/2008 8:37:55 PM
Reply:

Similar Artilces:

PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN Please turn off the CAPS Lock, more than two lines would be extremely difficult to read. Reading caps is annoying. Format the column as text, if the leading zero is important to you then it is an identification not a number. The default alignment for text is left aligned which is also better for most identification "numbers". Credit card numbers are 16 digits, are identification and can not be entered as numbers, ever, because Excel only retains 15 si...

Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions for the pictures. So I make a tiny textbox that I put under the picture, and type in a caption into that textbox. The problem is that I can make the picture have some space to left and right of it so that text doesn't crowd into the picture, but I can't do that with the textbox containing the caption. Is there any way to prevent outside text from crowding the borders of a textbox? You can move that textbox wherever you need. You don't need to leave space inside when you can steer clear of the textbox itself. ...

Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is a good idea. Is there a better place to store these statements?? Thanks in advance for any responses. Dominic Inline in the code, they arnt particually helpful to put in the string table. -- - Mark Randall http://zetech.swehli.com "Those people that think they know everything are a great annoyance to those of us who do" Isaac Asimov <dominicgualtieri@hotmail.com> wrote in message news:1129050897.519688.176820@g49g2000cwa.googlegroups.com... >I am wondering if putting all my SQL statements in...

Put app and icon in task bar?
I have an MFC application that I want to be able to put in the task bar as a small icon and have it pop up the dialog when selected from the task bar. This app is intended to be run from the start up menu and be minimized in the task bar along with all the other start items... Pointers on how to please... By default app goes on the task bar. Do you mean system tray (that by default appears on the bottom right of the screen)? -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "ShipHead" <GoAway@SpamBoy.com> wrote in message news:#g1K8UgEFHA.2700@TK2MSFTNGP14.phx.gbl... > I...

outlook ka-put
After I installed the service pack updates for Microsoft XP, my Outlook has been uable to send or receive any email. I have gotten a few error messages: "unable to connect to network," "server found but did not respond." etc. What the heck do I do? ...

Where to put error handler code for "No current record" error?
Hello, to brighten the essence of my current problem I woud like to describe the situation from scratch. I use Acess 2007. I have two tables 'tblOrders' and 'tblOrderDetails' linked as ODBC tables from MS SQL 2000 Server. Both tables have primary keys: 'tblOrders' has 'orderId' primary key and 'tblOrderDetails' has a pair 'orderId' and 'itemId' as primary key. On server there is also a foreign key constraint defined on key 'orderId' between both tables. In access I have a main form 'frmOrders' bounded to 'tblOr...

How do I put it back?
In Microsoft money 2003. Used to: When I put on my paycheck I would have a window pop up with seperate catagories, "taxes", "healthcare", ect. there were four of them. Now when I put them in I just get one "spit catagories" window. I don't know how I changed it or how to change it back. I can't even find any support that can/ will help me. If anyone knows Please let me know. I will be greatly indeted to you. thank You. Derek "Derek" <Derek@discussions.microsoft.com> wrote in message news:D9D38C7E-D837-4376-99D3-79C760EC4F85@mic...

Put % in ( )
Dear all, Is it possible to format a cell to stay like it: ( -10% )? With this format (0%), the excel shows this - (10%) Thanks a lot!!! Andr=E9. Try this Custom Number Format: Select the cell(s) to be impacted From the Excel Main Menu: <format><cells><number tab> Category: Custom Type: (0%);(-0%);(0%) Click [OK] Those settings will display: 10% as (10%) -10% as (-10%) 0% as (0%) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) <gatarossi@ig.com.br> wrote in message news:4188b0ad-a272-455...

how to put constraints in excel
how to put constraints in excel You need to be more specific in your question. Perhaps Data Validation, on the Data menu, will do what you want. This will allow users to enter only values in a range of numbers in a cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "structures" <structures@discussions.microsoft.com> wrote in message news:EFC87EE4-BC1A-4F88-9E35-0EB42F42881C@microsoft.com... > how to put constraints in excel ...

How do put a Logo on the Receipt
Is there anyway I acn put a logo on my Receipt. If I remember I simply copied out the file pos_symbol.gif in C:\Program Files\Microsoft Retail Management System\Store Operations\HTML\Images to get the size, and then renamed that file, uploaded one of my own. Chris "al" wrote: > Is there anyway I acn put a logo on my Receipt. that did not worked, can you be more detailed about it "Chris" wrote: > If I remember I simply copied out the file pos_symbol.gif in C:\Program > Files\Microsoft Retail Management System\Store Operations\HTML\Images to get > the ...

putting photos into autoshapes
I publish a newsletter for a charity and would like to improve and vary the presentation. How do I make a standard photo go into an oval or other autoshape? I have done it once but can't recreate it. I have windows XP, publisher 03 and works suite 04. My photos are usually JPEG. Select the shape, fill, fill effects, picture tab. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "christiredlady(removethis)@aol.com" <christiredlady(removethis)@aol.com@discussions.microsoft.com> wrote in message news:069B7725-3...

Way to put multiple rows into the same column.
I have data that is in the format of 3 columns wide by about 3000 rows. I want to rearrange each row to become a single column. Eg. Cells A1,B1,C1,A2,B2,C2 to become in cells A1,A2,A3,A4,A5,A6 respectively. I have transposed the data but this only puts each row in it's own column. I still need to put all the new columns into one column. Thankyou for any help given. Hi, Try my EastyText_Rev1.xls at http://www.geocities.com/excelmarksway It might work, er, maybe, hmmm... - Mark >-----Original Message----- >I have data that is in the format of 3 columns wide by about 3000 r...

I need to pull out a users email from Exchagne 2003 and put it into a .pst
I think I'm supposed to use ExMerge.exe, but when I try to run it, I get the error: "This application has failed to start because EXCHMEM.dll was not found. Re-installing the application may fix this problem". I found the application at: http://www.microsoft.com/downloads/details.aspx?FamilyID=429163ec-dcdf-47dc-96da-1c12d67327d5&displaylang=en I installed it into "Program Files\exchsrv\bin" Never mind.... "Galvanon" <galvanon@online.nospam> wrote in message news:e7iaMaxYGHA.3704@TK2MSFTNGP03.phx.gbl... > I think I'm suppose...

How Do I put Excel data into Publisher?
Hi, I am trying to produce a booklet in Publisher, when I transfer/copy the data from Excel it is too wide for the page, so I rotate the object to be portrait. This looks fine on screen, but when printed it come out the original way, i.e. landscape. I have tried to put it in as .pdf but the same happens. Does anyone have any idea on how to do this. Regards Cheryl I have no problem here, Cheryl - just copied data from XL, pasted into Pub, rotated & printed. Are you doing anything differently... Some kind of Paste Special or different print settings? Make sure there is nothing in ...

Tables not staying put
In Word 2008, I have a few tables that I am trying to set on top of each other. In a couple of cases, if I try to move the table down by putting returns between the tables, the bottom table moves down then jumps back up again. If you show special characters you can see the returns on the left of the table in the margin instead of between the tables. In Draft mode, it shows the separation correctly, but not in Print mode. As I add more returns, sometimes the tables rows seem to disappear - other times the table might jump into/over the other table. What is causing this? ...

Using Excel to input survey Information- How do I put checks against myself?
I need to make certain cells accept only "x" and nothing else. I have no idea why this is becoming such a difficulty. Also, I have data sets in there own colum. I need to mark an "x" under yes, no, or not sure. However, if I move too fast, I might put an "x" under yes and not sure. Is there any way to check for that? This sheet is going to get quite large, and manual rechecking will be a huge pain. Anyone have any idea's? Oh! I'm running Excel 2002. -- kinjour ------------------------------------------------------------------------ kinjour's Prof...

When should I put a DC at a site?
We are planning an AD rollout. All AD servers will be Server 2008 R2. We have a main office that will house 2 DCs, 8 offices all over the US that are directly connected to our main office via point to point T1's and several branch offices that are connected via VPN over the internet. The 8 offices have between 15 and 65 users at them and the branch offices all have 10 or fewer users. Assume that all sites' point to points are very reliable and rarely go down. Also assume that when any of the sites' point to points go down, they all fall back to vpn over their i...

why put a string be put in the string table and not a header file?
I have found it is easier to work with string defintitions that are placed in a separate header file (i.e. files with extensions '.h') than placing them in the string table. For example, all error messages can be placed in a file named 'ErrorMessages.h'. If different languages are to be supported, one could create a separate header file for each language (e.g. EnglishErrorMessages.h, FrenchErrorMessages.h, etc). It is easier to work with a simple header file than the string table. Furthermore, using the resource editor to edit a string table is a slow and tedious work, p...

Need help reverse figuring our an amortization to put in Excel mat
Hi, I have a sample Excel (what I was told was done in Excel) spread sheet that does loan amortization and one can change a number of variables. We need to recreate this not knowing the math/formulas that underlie this. Is someone good at looking at this and figuring out what needs to be inputed into Excel to make this work? Make it live? I can send a screen shot of the form to anyone that can assist! Thanks in Advance -- Dodge i can send you one or two id you send me an email. -- Gary Keramidas Office 2010 "Dodge" <Dodge@discussions.microsoft.com> w...

Export-CSV
Why does Export-CSV put quotes around everything? Sure, this is a valid CSV, technically, but it feels like a clunky implmentation. Only values with delimiters within them should have to be quoted. Is there a way to turn this off and make it more RFC4180 compliant? Thanks. -- Kevin Buchan kevin.buchan@troutman[nospam]sanders.com Because its easier to quote everything rather than not. You can have whitespace, embedded quotes, etc. C/C++ has taken this same approach when it comes to several concepts one would be enums and the trailing ',' which is ignored bec...

Pulling parts of information from one cell and putting in another
Bascially I have no clue how to do this and am not sure if it is possible. I am try to pull from my long description to make a short description. This is my long description in one cell "An undercover FBI agent working as a legal clerk at a casino uncovers illegal gambling activities in the small California desert town of 29 Palms, but before he can turn in his report, his boss turns on him and hires one of the best hit-men in the business to take him out. With the deal sealed and payment in hand, the hit-man is on his way, but loses his bag of money to a crazed security guard ...

Borders to stay put!
I am writing a template for someone and they want to have the dotted line around each cell. However, when they get hold of the template, what they are doing is inserting more lines and deleting certain cells and they are losing the dotted formatting on certain cells that have had the contents deleted. Basically - is there a way to make the border formatting stick no matter what happens to the content of the cell so that there will be a dotted border line round all cells no matter what? nikwak You may be able to have a macro that reapplies your border, but it may be simpler to find out what ...

Put "put user form" in spreadsheet
Hi all, I have created a user form VBA. When I open the VBA Project window I have: VBAProject (file name) + Microsoft Excel Objects Sheet 1 This Workbook + Forms Name of the form I created What I want to do in the spreadsheet is create a command that when clicked will bring this form up. The boxes in the form are designed to go to various cells in the worksheet. How do I accomplish this? Is there a code that I am supposed to write that will automatically go the form? I am not the greatest when coming to working with commands in Excel. Any help would be g...

How do I put Advanced Find into the context Menu
Hello, In Outlook 2007 MS removed the find function from the right click context menu and hid it in the menus at the top. I won't use the Desktop Search tool because I hate it. Is there anyway to put the anvanced find back into the outlook context menu? Thanks "Gilgamesh" <gilgamesh@dont.spam.me> wrote in message news:#q6NFMo4JHA.4272@TK2MSFTNGP06.phx.gbl... > Hello, > In Outlook 2007 MS removed the find function from the right click context > menu and hid it in the menus at the top. It's not "hidden" here - it's staring me right in the ...

Can't put range on chart
Hello, I have a spreadsheet with 50 tabs. Each tab has a 6 month audit score that looks like this: MAR APR MAY JUN JUL AUG 100% 100% 100% 100% 100% 100% There is a bar graph linked to these cells on each tab. What I am trying to do is group the tabs together, then delete the MAR score, shift all cells to the left, then add a SEP score. The problem is... when I try to do that, the graph changes to only show APR MAY JUN JUL & AUG. I can't get it to automatically add SEP. I could do it individually but that would be very time consuming to do it for 50 ...