Formatting

  • Thread starter Thread starter shternm
  • Start date Start date
S

shternm

I would like to have (1,234,567) read like (1,234) and the vice vers
with positive numbers.
I got as far as
#,###,_);(#,##0)
but that doesn't cover negative numbers.

Th
 
You must log in or register to reply here.

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

how to format cells so that it only shows thousands. 1
number format - align decimal point but not minus sign 3
Custom number format 4
How do I format a number to cut off the thousands? 1
Round number to the thousands without changing underlying number 3
Number format in text cell 1
Formula Help 3
format a number field to only show 2 decimal places if there are a 6

Back
Top