Comma Style?

Topics: User Forum
Jun 11, 2008 at 3:44 AM
Is there a way to style a cell with "Comma Style", e.g., "1000000" as "1,000,000"?
Jun 11, 2008 at 6:38 AM
Try setting the number format 0.000,00 or something similar.
Jun 11, 2008 at 3:38 PM
Edited Jun 11, 2008 at 3:39 PM

maartenba wrote:
Try setting the number format 0.000,00 or something similar.

After playing around with some custom formats in Excel itself, I came up with #,##0.00

But unlike Comma Style, the text is aligned to the very very right--it doesn't line up with Currency-formatted numbers. Here's a screenshot that illustrates the problem:

Sub Total and Total are formatted using FORMAT_CURRENCY_USD_SIMPLE.
Jun 11, 2008 at 5:37 PM
FORMAT_CURRENCY_USD_SIMPLEis defined as "$"#,##0.00_-
(This is an Excel standard format)
Note the "_-" at the end.
This includes a space after the value

Your normal comma separated, 2dp mask is #,##0.00
No "_-" at the end, so no space after the value.

Use #,##0.00_- for the non-currency values, and they should then line up
<a id="ctl00_ctl00_Content_TabContentPanel_Content_PostRepeater_ctl04_QuoteLink"
Jun 11, 2008 at 8:57 PM
Thanks Mark! Works perfectly.

Maybe if it's not much trouble, a constant could be added for this. It's strange to think I'm the first or only person that's ran into an instance where I needed to apply comma styling and didn't know what formatting string to use.
Jun 12, 2008 at 6:55 AM
These constants will be added in 1.6.2.