| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom cell format for percentage
I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to figure out if there is a way to make them display as (-100%) instead (with brackets but not in red). Does anyone know if this is possible? Thanks very much |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom cell format for percentage
Format--Cells--Custom format
0.00%;(-0.00%) This will put a parentheses around a negative percent as well as put the negative sign. -- John C "Klee" wrote: I'm trying to figure out how to do a custom cell format for percentages. Currently the negative percentage numbers show up as -100%. I'm trying to figure out if there is a way to make them display as (-100%) instead (with brackets but not in red). Does anyone know if this is possible? Thanks very much |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom cell format for percentage
Thanks so much, I thought I had tried that but it was making all of my
positive amounts negative so I must have done something wrong. It works great now. Thanks again! "John C" wrote: Format--Cells--Custom format 0.00%;(-0.00%) This will put a parentheses around a negative percent as well as put the negative sign. -- John C "Klee" wrote: I'm trying to figure out how to do a custom cell format for percentages. Currently the negative percentage numbers show up as -100%. I'm trying to figure out if there is a way to make them display as (-100%) instead (with brackets but not in red). Does anyone know if this is possible? Thanks very much |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom cell format for percentage
Thanks for the feedback, and don't forget to check the box :)
-- John C "Klee" wrote: Thanks so much, I thought I had tried that but it was making all of my positive amounts negative so I must have done something wrong. It works great now. Thanks again! "John C" wrote: Format--Cells--Custom format 0.00%;(-0.00%) This will put a parentheses around a negative percent as well as put the negative sign. -- John C "Klee" wrote: I'm trying to figure out how to do a custom cell format for percentages. Currently the negative percentage numbers show up as -100%. I'm trying to figure out if there is a way to make them display as (-100%) instead (with brackets but not in red). Does anyone know if this is possible? Thanks very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Font color automatically when Cell Format is Percentage | Excel Worksheet Functions | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| FORMAT PERCENTAGE IN INDEX CELL? | New Users to Excel | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Linear Mode
