String Format for Thousand separators

Question

Is there a way using String Formatter I can achieve the following:

$52,152 to $52.1

I have a series of values that are all thousands and I will like to display them in the above format.

Thanks

Do you have those values as string or as a numeric data type? — Daniel Hilgarth, Sep 17 '13 at 14:56
http://msdn.microsoft.com/en-us/library/0c899ak8.aspx `,` scaling specifier — Ry-, Sep 17 '13 at 14:57
@AustinSalonen because number formatting is most an UI thing. ASP.NET will usually deal with that automatically based on the language information of the user's browser. On WPF and Windows Forms, though, there are many ways a person may forcefully hard code one formatting or the other. — Geeky Guy, Sep 17 '13 at 14:57
Look how I want from $52,152 (with comma) to $52.1 (with a period). Not sure if that is possible — franciscovalera, Sep 17 '13 at 14:59
If you're starting with an input string of `$52,152` - where is it coming from? It may be more logical to do this conversion earlier in the chain... — J..., Sep 17 '13 at 15:03
Good reference : http://stackoverflow.com/questions/11731996/string-format-numbers-thousands-123k-millions-123m-billions-123b — Jason Evans, Sep 17 '13 at 15:15

Ry- · Accepted Answer · 2013-09-17T15:18:16.653

3

This works for $52.2, using the , number scaling specifier:

string.Format("{0:$0,.0}", 52152);

If you really want 52.1, you’ll probably have to do it “manually”; sorry. All custom formatting strings seem to round.

edited Sep 17 '13 at 15:18

answered Sep 17 '13 at 15:05

Ry-

218,210
55
464
476

Do you read @p.s.w.g question in OP comments? Also, there are more correct ways to achieve this result. – Hamlet Hakobyan Sep 17 '13 at 15:07
@HamletHakobyan: Yes, I did read that question. And what in the world do you mean by “more correct”? – Ry- Sep 17 '13 at 15:08
This led me to achieve the answer but I ended up using : {$0,.0} – franciscovalera Sep 17 '13 at 15:09
For instance by setting `NumberFormatInfo`. – Hamlet Hakobyan Sep 17 '13 at 15:11
@HamletHakobyan: you cannot scale numbers with a custom [`NumberFormatInfo`](http://msdn.microsoft.com/en-us/library/system.globalization.numberformatinfo.aspx). – user7116 Sep 17 '13 at 15:16

score 1 · Answer 2 · answered Sep 17 '13 at 15:07

In your case the non-formatted versions of your 2 numbers are inherently different

52152 != 52.1

A better solution might be to send the correct numbers to the UI but if not, you can use the , scaling specifier - http://msdn.microsoft.com/en-us/library/0c899ak8.aspx#SpecifierTh

void Main()
{
    decimal x = 52152M;

    var a = string.Format("{0:C}", x); //Current Format in Local Culture
    Console.WriteLine(a); //Prints €52,152.00

    var b = string.Format("${0:00000}", x); //Custom Format, no decimals
    Console.WriteLine(b);//Prints $52152

    var c = string.Format("${0:###,###,###}", x); //Custom Format, no decimals + 1000 seperators
    Console.WriteLine(c);//Prints $52,152

    var d = string.Format("${0:###,###,.0}", x); //Custom Format, 1 decimal place, 1000 seperators to support values over 1 million
    Console.WriteLine(d);//Prints $52.2

}

score 1 · Answer 3 · answered Sep 17 '13 at 15:10

Something like this?

string input = "$52,152";
var number = long.Parse(input, NumberStyles.Currency);
string result = (number / 100L / 10m).ToString("C1");

Explanation. First division is an integer division that truncates. Second division is a System.Decimal division.

This assumes a culture (for example new CultureInfo("en-US")) where the currency sign is "$" and the thousands separator is ",".

String Format for Thousand separators

3 Answers3