format negative figs

  • Thread starter Thread starter Julia
  • Start date Start date
J

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number Formats - Help 3
Excel not using regional settings 6
Displaying negatives with (brackets) 3
Negative Numbers in Brackets 2
Red cell for negative numbers in Excel 1
Lining up decimal points with negatives in brackets 2
How do I align numbers in different cells when some are in bracke. 2
Negative Numbers 8

Back
Top