Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Your Answer


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.