format negative figs

[Julia]

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

 

[Mike H]

Julia,

Try this custom format

#,##0.00;(#,##0.00)

Mike

 

[Eduardo]

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

 

[FSt1]

hi
there is a custom format for that.
i'm using 2003 so
format>cells>number tab>custom>scroll to.....
#,##0,00:[RED](#,##0.00)

regards
FSt1

 

[Julia]

Thanks Mike that is exactly what I needed

Julia,

Try this custom format

#,##0.00;(#,##0.00)

Mike