C# DataFormatString for thousands dot separator (Asp.net mvc)

Question

In my model I want to format the output of a double. I'm trying to output a number like this:

100000000 as 100.000.000 (simply a dot separator)

But by using this (currency format)

[DisplayFormat(DataFormatString = "{0:C}")]

Result => 424.232.344 kr

I also get the currency symbol (depending on the culture, in my case "kr") and I don't want that. I simply want the dot separator but without the currency.

Any suggestions?

Does {0:#,#} work? -- See also Custom Numeric Format Strings — Corak
– Corak, Commented Jan 29, 2016 at 8:45
check this for more options msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx — Ian
– Ian, Commented Jan 29, 2016 at 8:46
@Ian - yes, that is probably, because the thousands-separator of your current(UI)culture has it defined like that. Sorry, I'm not versed enough in MVC to know how you can specify a different language. Usually, you can do something like 1000.ToString("#,#", CultureInfo.GetCultureInfo("de-DE")). But I think that's not possible with data annotations, because the culture isn't a compile constant. — Corak
– Corak, Commented Jan 29, 2016 at 8:58

Community · Accepted Answer · 2017-05-23 11:52:47Z

5

Because "C" means currency in that format specifier and it uses CurrencySymbol of your CurrentCulture setting.

You can use The "N" format specifier instead.

[DisplayFormat(DataFormatString = "{0:N0}")]

Based on your comment, looks like your CurrentCulture using white space as NumberGroupSeparator but uses . as a CurrencyGroupSeparator.

In such a case, you can set it's NumberGroupSeparator to . and you will be fine.

Read: Is there a way of setting culture for a whole application? All current threads and new threads?

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jan 29, 2016 at 8:49

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

ChrisRun Over a year ago

Yes I am aware that C stands for currency. I Have tried your suggestion and it returns 424 232 344,00 (spaces instead of dots.)

Soner Gönül Over a year ago

@ChrisRun Updated my answer. Take a look.

ChrisRun Over a year ago

Thanks, but unfortunately I'm not able to set the NumberGroupSeparator in this case, since the instance is readonly.

Soner Gönül Over a year ago

@ChrisRun NumberGroupSeparator property is not read-only but your culture setting might be. Have you ever check this question for this? stackoverflow.com/q/18728505/447156

ChrisRun Over a year ago

My mistake, yes you are correct, the culture setting is readonly. Have not, will check it out, thanks.

Collectives™ on Stack Overflow

C# DataFormatString for thousands dot separator (Asp.net mvc)

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related