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

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

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

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

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