Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .