| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format negative figs
How do I format a negative number as follows (1,000) I can get either the
brackets or the comma separator but not both! Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format negative figs
Julia,
Try this custom format #,##0.00;(#,##0.00) Mike "Julia" wrote: How do I format a negative number as follows (1,000) I can get either the brackets or the comma separator but not both! Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format negative figs
Hi Julia
Right Click in the mouse, Format cells., number, custom, look for the formula #,##0;[Red]-#,##0 and where the formula is displayed ( Type) add the parentesis as follow #,##0;[Red](#,##0) I deleted as well the - signal you can leave if you prefer "Julia" wrote: How do I format a negative number as follows (1,000) I can get either the brackets or the comma separator but not both! Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format negative figs
hi
there is a custom format for that. i'm using 2003 so formatcellsnumber tabcustomscroll to..... #,##0,00:[RED](#,##0.00) regards FSt1 "Julia" wrote: How do I format a negative number as follows (1,000) I can get either the brackets or the comma separator but not both! Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format negative figs
Thanks Mike that is exactly what I needed
"Mike H" wrote: Julia, Try this custom format #,##0.00;(#,##0.00) Mike "Julia" wrote: How do I format a negative number as follows (1,000) I can get either the brackets or the comma separator but not both! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update figs from following 1 Jan after 4th anniversary (2003) | Excel Discussion (Misc queries) | |||
| percentage/figs on the same graph | Charts and Charting in Excel | |||
| Format to a negative value | Excel Worksheet Functions | |||
| I need to math manipulate figs over 10,000( in hrs & min format)? | Excel Discussion (Misc queries) | |||
| How do I format a negative percent? | Excel Discussion (Misc queries) | |||
Linear Mode
