How would I separate thousands with space in C#

Question

Assume I have the following decimal number that I have to format so that every thousand should be separated with a space:

 897.11 to 897.11
 1897.11 to 1 897.11
 12897.11 to 12 897.11
 123897.11 to 123 897.11

I have tried Decimal.ToString("0 000.00"). Although this works pretty well when the number is 1897.11. But when it's 897.11 I get 0 897.11.

score 95 · Accepted Answer · edited Apr 23 '16 at 20:50

95

Pass in a custom NumberFormatInfo with a custom NumberGroupSeparator property, and use the #,# format to tell it to do number groups. This example uses the invariant culture's number format as its basis.

var nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone();
nfi.NumberGroupSeparator = " ";
string formatted = 1234897.11m.ToString("#,0.00", nfi); // "1 234 897.11"

edited Apr 23 '16 at 20:50

n00b

5,642
2
30
48

answered Jul 08 '13 at 13:32

Tim S.

55,448
7
96
122

4

+1 , I have edited this answer to handle zero values properly - the previous format string "#,#.00" caused zero to be represented as ".00" now it is "0.00" – n00b Apr 23 '16 at 20:51

score 23 · Answer 2 · answered Jul 08 '13 at 13:35

You need a custom number format provider where you change the character yourself:

    static void Main(string[] args)
    {
        decimal d = 2000000;

        var f = new NumberFormatInfo {NumberGroupSeparator = " "};

        var s = d.ToString("n", f); // 2 000 000.00
    }

Here I also specify to format it as a number (using "n"), please see this link for other formatting options:

Standard Numeric Format Strings

In this case, it won't work if you format as a currency or a percentage, because as you may already note the NumberFormatInfo has separate properties for those.

The current culture format info can be found on System.Globalization.CultureInfo.CurrentCulture.NumberFormat.

score 13 · Answer 3 · answered Jul 08 '13 at 13:32

13

try this

int testNumber = 134566548;
Console.WriteLine(string.Format("{0:N}", testNumber));

You will received : 134 566 548,00

Don't forget your culture.

answered Jul 08 '13 at 13:32

Matthieu M

149
3

Charles Bretana · Answer 4 · 2013-07-08T13:34:16.607

11

with a custom format string, but use '#' not '0's a 0 is a mandatory token it will be there no matter how long the number is, the pound sign (#) is optional token, it will only be used for digits actually in the number.

  Decimal.ToString("# ###.00")

NOTE. I'll leave this here, but @Tim S' answer is a better one.

When I try this I see it only generates the first separator... I guess the separator only works for commas and periods here. As a workaround (up to the maximum size number you expect), try this instead.

  Decimal.ToString("# ### ### ### ###.00")

edited Jul 08 '13 at 13:34

answered Jul 08 '13 at 13:27

Charles Bretana

143,358
22
150
216

For `1234897.11` this results in `1234 897.11` (i.e. it only separates the first group). – Tim S. Jul 08 '13 at 13:29
@Tim, that sounds like a bug in the framework code. see my edit – Charles Bretana Jul 08 '13 at 13:32
2

@Tin S answer is better than mine. Did not know `NumberFormatInfo` existed – Charles Bretana Jul 08 '13 at 13:36
1

I feel like this one is more obvious at a glance what it is doing. – PRMan Oct 04 '14 at 12:39
for 0.1 it returns ".1". For fix it try Decimal.ToString("# ##0.00") and you may need .Trim() – razon Oct 04 '17 at 12:26

score 4 · Answer 5 · answered Sep 20 '16 at 15:55

4

Norwegian locale uses spaces as a separator, so if you were designing a website or application specifically for Norwegians, then you could use:

(123897.11).ToString("n",new CultureInfo("nb-NO"))

Which results in

"123 897,11"

Obviously, if you're not writing an application for the Norwegian market, then this would be a silly solution.

answered Sep 20 '16 at 15:55

Fiach Reid

6,149
2
30
34

I used something like `(123897.11).ToString("n4",new CultureInfo("nb-NO"))` for 4 decimal places. Tks. – sergiol Nov 22 '22 at 16:14

score 4 · Answer 6 · answered Jan 21 '20 at 05:42

4

Sweden Use thousand separator as Space(" ") and Decimal point separator as Comma(,). We can achieve this in the following way.

decimal myNumbber = 5878.476M;
var swedishCulture = new CultureInfo("sv-SE");           
swedishCulture.NumberFormat.NumberDecimalSeparator = ",";
swedishCulture.NumberFormat.NumberGroupSeparator = " ";
var s = myNumbber.ToString("#,###.00", swedishCulture);

Which gives the output

"5 878,48"

answered Jan 21 '20 at 05:42

Md. Nazrul Islam

2,809
26
31

1

Question, why would you need to specify the separator values? Aren't these already defined in the CultureInfo's NumberFormatInfo property? – Justin Greywolf Mar 17 '20 at 17:35

Diallo Mamadou safayiou · Answer 7 · 2023-05-18T14:47:53.280

0

double salaire = 0;
string salaire_s = "0";

private void txtSalaire_TextChanged(object sender, EventArgs e)
{
    txtSalaire.Text = FormatMontant(salaire_s);
    txtSalaire.Select(txtSalaire.Text.Length, 0);
}

private void txtSalaire_KeyPress(object sender, KeyPressEventArgs e)
{
    salaire = ClassUtility.AllowNumbersFormatDecimal(e, salaire_s);
    salaire_s = salaire.ToString();
}

public static string FormatMontant(string montant_string)
{
    double montant = 0;
    if (montant_string.Equals(""))
    {
        montant_string = "0";
    }
    montant = Convert.ToDouble(montant_string);
    return String.Format("{0:n0}", montant);
}

edited May 18 '23 at 14:47

answered May 18 '23 at 14:39

Diallo Mamadou safayiou

1
1

Thank you for your interest in contributing to the Stack Overflow community. This question already has quite a few answers—including one that has been extensively validated by the community. Are you certain your approach hasn’t been given previously? **If so, it would be useful to explain how your approach is different, under what circumstances your approach might be preferred, and/or why you think the previous answers aren’t sufficient.** Can you kindly [edit] your answer to offer an explanation? – Jeremy Caney May 18 '23 at 17:46

How would I separate thousands with space in C#

7 Answers7

Linked

Related