c# Decimal to string for currency

Question

To display a currency we do:

ToString("0.##")

For value 5.00 the output is:

For value 5.98 the output is:

5.98

For value 5.90 the output is:

5.9

I need the third case to come out with 2 decimal points, eg:

5.90

How can I do this without it affecting the other results?

Any reason you can't use the currency format string? `value.ToString("c")`? — Steve Danner, May 03 '12 at 18:41
Why not simply do `someDecimal.ToString("c", new CultureInfo("en-US"))`? It then also applies the currency symbol. — Tejs, May 03 '12 at 18:41
@Tejs we're writing our own store and it supports multiple currencies, that wont fit in with the design very well unfortunately at this stage! — Tom Gullen, May 03 '12 at 18:42
I don't think you can do that with any built-in or custom format strings (selectively either doing no decimal point or two decimal points). You may have to add logic to select one or the other or implement your own `IFormatProvider`. — Jacob, May 03 '12 at 18:43
@Jacob that's what I was thinking as well, just going to be a PITA to do at this stage! — Tom Gullen, May 03 '12 at 18:44
@TomGullen - Supporting multiple currencies isn't a problem, that's what the `new CultureInfo("en-US")` does. Try it with `new CultureInfo("en-GB")` or `new CultureInfo("fr-FR")`. — Justin Morgan - On strike, Jul 07 '14 at 16:42

Jonathan Wood · Answer 1 · 2021-10-24T21:26:09.757

26

Try:

value.ToString("#,##0.00")

Or just:

value.ToString("C")

I know of no built-in way to expand out all two decimal places only when both are not zero. Would probably just use an if statement for that.

if (s.EndsWith(".00"))
    s = s.Substring(0, s.Length - 3);

edited Oct 24 '21 at 21:26

answered May 03 '12 at 18:41

Jonathan Wood

65,341
71
269
466

1

The OP says that he wants the decimal portion to be omitted if it's an integer value. – Jacob May 03 '12 at 18:44

score 18 · Accepted Answer · answered May 03 '12 at 18:52

18

I know this doesn't give you a format that fixes the problem, but it's a simple solution to work around it.

(5.00).ToString("0.00").Replace(".00","");  // returns 5
(5.90).ToString("0.00").Replace(".00", ""); // returns 5.90
(5.99).ToString("0.00").Replace(".00", ""); // returns 5.99

answered May 03 '12 at 18:52

Zachary

6,522
22
34

shouldn't you be using `5.00m` and the like? – Sebastian Sep 19 '12 at 13:37
10

(5.00).ToString("C"); – Prince Chopra Oct 22 '14 at 09:59
How is this the accepted answer when the correct answer was given 11 minutes earlier? – Mike Devenney Feb 28 '19 at 02:24
1

@MikeDevenney Because the answer you're referring to didn't actually answer the question until August 2018. – Travis May 10 '19 at 21:14
@TravisSunderland Good call, I didn't notice that last part was added during the Aug edit. – Mike Devenney May 15 '19 at 14:16

score 11 · Answer 3 · edited Aug 24 '18 at 19:28

11

You could use an extension method, something like this:

public static string ToCurrencyString(this decimal d)
{
    decimal t = Decimal.Truncate(d);
    return d.Equals(t) ? d.ToString("0.##") : d.ToString("#, ##0.00")
}

edited Aug 24 '18 at 19:28

AustinWBryan

3,249
3
24
42

answered May 03 '12 at 19:03

Clark

376
1
6

score 10 · Answer 4 · answered May 03 '12 at 18:44

10

# means if there is no number leave it empty 0 means put a 0 if there is no number

ToString("0.00")

answered May 03 '12 at 18:44

ahaliav fox

2,217
22
21

Thanks for the explanation, I did not know that. – VictorySaber Jul 28 '16 at 16:45

score 1 · Answer 5 · answered Mar 17 '15 at 18:22

1

Not sure if I'm missing something, but can't you just do this:

decimal moneyvalue = 1921.39m;
string html = String.Format("Order Total: {0:C}", moneyvalue);
Console.WriteLine(html);

answered Mar 17 '15 at 18:22

gcoleman0828

1,541
3
30
49

score 0 · Answer 6 · answered Aug 12 '15 at 08:01

Just use myDecimal.ToString("N"),

With "N" parameter will transform decimal to string, and the number of decimals to show will be defined by your SO settings.

https://msdn.microsoft.com/en-us/library/system.globalization.numberformatinfo.numberdecimaldigits(v=vs.110).aspx

c# Decimal to string for currency

6 Answers6

Linked