CODEWITHSUNDEEP
c#asp.net-mvc-3formattingnumber-formatting
Krishan
Krishan

Reputation: 2477

Format a number with commas and decimals in C#

I need to display a number with commas and a decimal point.

Eg: Case 1 : Decimal number is 432324 (This does not have commas or decimal points).
Need to display it as: 432,324.00.
Not: 432,324

Case 2 : Decimal number is 2222222.22 (This does not have commas).
Need to display it as: 2,222,222.22

I tried ToString("#,##0.##"), but it is not formatting it correctly.

Upvotes: 61

Views: 277599

Answers (12)

Roys
Roys

Reputation: 1636

int number = 1234567890;
number.ToString("#,##0.00");

You will get the result 1,234,567,890.00.

Upvotes: 118

Nancy
Nancy

Reputation: 1

For anyone looking at this now, and getting the "No overload for method 'ToString' takes 1 argument" when using:

TotalNumber.ToString("N")

My solution has been to use :

TotalNumber.Value.ToString("N")

I often get stuck on this when working directly inside an MVC View, the following wasn't working:

@Model.Sum(x => x.Number).ToString("N")

Whereas this works:

@Model.Sum(x => x.Number).Value.ToString("N")

Upvotes: 0

Marcello B.
Marcello B.

Reputation: 4420

If you are using string variables you can format the string directly using a : then specify the format (e.g. N0, P2, etc).

decimal Number = 2000.55512016465m;
$"{Number:N}" #Outputs 2,000.55512016465

You can also specify the number of decimal places to show by adding a number to the end like

$"{Number:N1}" #Outputs 2,000.5
$"{Number:N2}" #Outputs 2,000.55
$"{Number:N3}" #Outputs 2,000.555
$"{Number:N4}" #Outputs 2,000.5551

Upvotes: 2

Abolfazl Rastgou
Abolfazl Rastgou

Reputation: 832

Try with

ToString("#,##0.###")

Produces:

1234.55678 => 1,234.556

1234 => 1,234

Upvotes: 11

Sagar Mahajan
Sagar Mahajan

Reputation: 191

string Mynewcurrency = DisplayIndianCurrency("7743450.00");
        private string DisplayIndianCurrency(string EXruppesformate) 
        { 
        string fare = EXruppesformate;
        decimal parsed = decimal.Parse(fare, CultureInfo.InvariantCulture);
        CultureInfo hindi = new CultureInfo("en-IN");
     // string text = string.Format(hindi, "{0:c}", parsed);if you want <b>Rs 77,43,450.00</b>
    string text = string.Format(hindi, "{0:N}", parsed); //if you want <b>77,43,450.00</b>
      return ruppesformate = text;
    }

Upvotes: 0

JoshYates1980
JoshYates1980

Reputation: 3626

For Razor View:

[email protected]("{0:#,0.00}",item.TotalAmount)

Upvotes: 11

Wade Hatler
Wade Hatler

Reputation: 1835

I had the same problem. I wanted to format numbers like the "General" format in spreadsheets, meaning show decimals if they're significant, but chop them off if not. In other words:

1234.56 => 1,234.56

1234 => 1,234

It needs to support a maximum number of places after the decimal, but don't put trailing zeros or dots if not required, and of course, it needs to be culture friendly. I never really figured out a clean way to do it using String.Format alone, but a combination of String.Format and Regex.Replace with some culture help from NumberFormatInfo.CurrentInfo did the job (LinqPad C# Program).

string FormatNumber<T>(T number, int maxDecimals = 4) {
    return Regex.Replace(String.Format("{0:n" + maxDecimals + "}", number),
                         @"[" + System.Globalization.NumberFormatInfo.CurrentInfo.NumberDecimalSeparator + "]?0+$", "");
}   

void Main(){
    foreach (var test in new[] { 123, 1234, 1234.56, 123456.789, 1234.56789123 } )
        Console.WriteLine(test + " = " + FormatNumber(test));
}

Produces:

123 = 123
1234 = 1,234
1234.56 = 1,234.56
123456.789 = 123,456.789
1234.56789123 = 1,234.5679

Upvotes: 11

Matt Welson
Matt Welson

Reputation: 268

All that is needed is "#,0.00", c# does the rest.

Num.ToString("#,0.00"")

  • The "#,0" formats the thousand separators
  • "0.00" forces two decimal points

Upvotes: 5

DarkoM
DarkoM

Reputation: 335

CultureInfo us = new CultureInfo("en-US");
TotalAmount.ToString("N", us)

Upvotes: 8

Jeppe Stig Nielsen
Jeppe Stig Nielsen

Reputation: 61912

Maybe you simply want the standard format string "N", as in

number.ToString("N")

It will use thousand separators, and a fixed number of fractional decimals. The symbol for thousands separators and the symbol for the decimal point depend on the format provider (typically CultureInfo) you use, as does the number of decimals (which will normally by 2, as you require).

If the format provider specifies a different number of decimals, and if you don't want to change the format provider, you can give the number of decimals after the N, as in .ToString("N2").

Edit: The sizes of the groups between the commas are governed by the

CultureInfo.CurrentCulture.NumberFormat.NumberGroupSizes

array, given that you don't specify a special format provider.

Upvotes: 39

Patrick D&#39;Souza
Patrick D&#39;Souza

Reputation: 3573

Try with

ToString("#,##0.00")

From MSDN

*The "0" custom format specifier serves as a zero-placeholder symbol. If the value that is being formatted has a digit in the position where the zero appears in the format string, that digit is copied to the result string; otherwise, a zero appears in the result string. The position of the leftmost zero before the decimal point and the rightmost zero after the decimal point determines the range of digits that are always present in the result string.

The "00" specifier causes the value to be rounded to the nearest digit preceding the decimal, where rounding away from zero is always used. For example, formatting 34.5 with "00" would result in the value 35.*

Upvotes: 12

Belogix
Belogix

Reputation: 8147

Your question is not very clear but this should achieve what you are trying to do:

decimal numericValue = 3494309432324.00m;
string formatted = numericValue.ToString("#,##0.00");

Then formatted will contain: 3,494,309,432,324.00

Upvotes: 4

Related Questions