Convert decimal currency to comma separated value

Question

I get from a webservice the following strings:

12.95

or

1,200.99

Is there an option to convert these values to the following values without manipulating the string?

12,95

or

1200,99

I tried it with some Culture options but didn't get it right...

EDIT

I tried this:

    //return string.Format( "{0:f2}", Convert.ToDecimal( price ) );
    //return string.Format(CultureInfo.GetCultureInfo("de-de"), "{0:0}", price);

                

    NumberFormatInfo format = new System.Globalization.NumberFormatInfo();

    format.CurrencyDecimalDigits = 2;
    format.CurrencyDecimalSeparator = ",";
    format.CurrencyGroupSeparator = "";

    return decimal.Parse(price).ToString(format);

Im pretty sure its based on the culture settings http://stackoverflow.com/questions/1265773/how-can-i-globally-set-the-culture-in-a-wpf-application — DotNetRussell, Nov 13 '13 at 14:02

score 7 · Accepted Answer · answered Nov 13 '13 at 14:10

7

var input = "1,200.99";

//Convert to decimal using US culture (or other culture using . as decimal separator)
decimal value = decimal.Parse(input, CultureInfo.GetCultureInfo("en-US"));

//Convert to string using DE culture (or other culture using , as decimal separator)
string output = value.ToString(CultureInfo.GetCultureInfo("de-DE"));

Console.WriteLine(output); //1200,99

answered Nov 13 '13 at 14:10

Meta-Knight

17,626
1
48
58

exactly what I was looking for, thanks to you and all others! missing clue was adding the culture to the input string. – tronc Nov 13 '13 at 14:15

Joe Ratzer · Answer 2 · 2013-11-13T14:41:09.167

1

What about something like this:

    double number;
    double.TryParse("1,200.99", NumberStyles.Any, CultureInfo.CreateSpecificCulture("en-US"), out number);
    var formattedNumber = number.ToString(CultureInfo.CreateSpecificCulture("de-DE"));

Then return or write out formattedNumber (whatever you need to do).

edited Nov 13 '13 at 14:41

answered Nov 13 '13 at 14:07

Joe Ratzer

18,176
3
37
51

1

input: 4.95, number is then 495.0 and formattedNumber 495 ... my brain hurts ;) – tronc Nov 13 '13 at 14:11
The above code example assumes your machine has the same culture as the input, otherwise specify it in the TryParse method - http://msdn.microsoft.com/en-us/library/3s27fasw(v=vs.110).aspx – Joe Ratzer Nov 13 '13 at 14:14
1

Given your problem with the input culture, I've updated the answer in case it helps others... – Joe Ratzer Nov 13 '13 at 14:42

score 0 · Answer 3 · answered Nov 13 '13 at 14:03

Yes and no. First, what you have is a string, and so you cannot change the formatting of it as you're attempting to. However, to achieve what you would like, you can parse the string into a decimal value and then use the formatting options for decimals to display it in any reasonable way.

score 0 · Answer 4 · answered Nov 13 '13 at 14:07

0

You may try for something like this:

String.Format("{0:#,###0}", 0);

or may be like this:

string str = yourNumber.Remove(",").Replace(".",",");

answered Nov 13 '13 at 14:07

Rahul Tripathi

168,305
31
280
331

score 0 · Answer 5 · answered Nov 13 '13 at 14:14

Close enough tronc,

Try this snippet:

String curStr = "12.95";
Decimal decVal;
var valid = Decimal.TryParse(curStr, out decVal);
if (!valid) throw new Exception("Invalid format.");
String newFormat = decVal.ToString("C", System.Globalization.CultureInfo.CreateSpecificCulture("de-DE"));

Within the toString(...) call, you can append a number after 'C' to specify how many decimal places should follow. E.g "C3".

Convert decimal currency to comma separated value

EDIT

5 Answers5

Linked