Add Thousand Separator To A Double Value(Control Decimals, Remove Zero Decimals)

Question

Possible Duplicate:
.NET String.Format() to add commas in thousands place for a number

i have a double value that i want to add it thousand separator, with below conditions :
1- remove zero decimals after dor(.)
2-control count of decimals

for example :

string str_Money = Convert.ToDouble(Money).ToString("N3");

this code for Money = 50000 returns 50,000.000, but i don't want zero decimals(mean i want 50,000)
another example : for Money = 50000.2355 returns 50,000.235 and that is exactly what i want
how can i reformat it?

So, you want the thousands separator, but nothing following the decimal point ever (i.e. round)? Or only put two digits after decimal point if one is non-zero? I'm confused. — theMayer, Dec 15 '12 at 03:47
Money and `Double` in one sentence is a huge red flag. Use `Decimal` to represent money. — CodesInChaos, Dec 15 '12 at 15:42

score 1 · Accepted Answer · edited May 23 '17 at 11:47

1

Using the accepted answer from .NET String.Format() to add commas in thousands place for a number, use an if statement to control to returned format.

string str_Money = "";
if (money % != 0) // test for decimals
{
    str_Money = string.Format("{0:n0}", money); // no decimals.
}
else
{
    str_Money = string.Format("{0:n}", money);
}

edited May 23 '17 at 11:47

Community

1
1

answered Dec 15 '12 at 04:04

jac

9,666
2
34
63

1

The format can be selected using `?:` within the `Format`: `string.Format(money % 1 <> 0 ? "{0:n0}" : "{0:n}", money)`. – HABO Dec 15 '12 at 04:16
hi, what is this <> sign in c#? – SilverLight Dec 15 '12 at 13:14
My bad, I still type other language syntax sometimes. It should be != – jac Dec 15 '12 at 15:38

Add Thousand Separator To A Double Value(Control Decimals, Remove Zero Decimals)

1 Answers1