Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm trying to emulate the Comma style in Excel 2010.

From what I can tell, this appears to be the same as having the Number format set with "Decimal Places" set to 2 and the "Use Thousands Separator" checked.

Are there any other subtle differences I should be aware of?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

There is no difference in internationalization between the two formats. Excel will handle this automatically.

Some actual differences are

  1. The comma style puts a "-" for a value of 0.

  2. The comma style uses parentheses for negative values.

  3. The comma style has different spacing.

The following represents these differences

  Comma  |Number with thousands separator
1,000.00 |                       1,000.00
   10.00 |                          10.00
      -  |                           0.00
 (10.00) |                         -10.00

If you want to specify the comma style as a number format you can use the custom string

"_(* #,##0.00_);_(* (#,##0.00);_(* \"\" - \"\"??_);_(@_)"
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.