Convert string to decimal, keeping fractions

Question

I am trying to convert 1200.00 to decimal, but Decimal.Parse() removes .00. I've tried some different methods, but it always removes .00, except when I supply a fraction different than 0.

string value = "1200.00";

Method 1

 var convertDecimal = Decimal.Parse(value ,  NumberStyles.AllowThousands
       | NumberStyles.AllowDecimalPoint | NumberStyles.AllowCurrencySymbol);

Method 2

 var convertDecimal = Convert.ToDecimal(value);

Method 3

var convertDecimal = Decimal.Parse(value,
       NumberStyles.AllowDecimalPoint, CultureInfo.InvariantCulture);

How can I convert a string containing 1200.00 to a decimal containing 1200.00?

I think the zeros are implicit. The ".00" part exists in the decimal even if you don't see them. For formatting purposes you should show them but instead you don't have to worry. — Nelson Miranda, Nov 24 '10 at 08:31
@nmiranda: No, `decimal` maintains the appropriate scale. `decimal.Parse("1200.000")` and `decimal.Parse("1200.00")` will return distinct values, preserving the number of trailing 0s. — Jon Skeet, Nov 24 '10 at 08:34
I agree with @NelsonMiranda. In fact decimal.Parse("1200.000").Equals(decimal.Parse("1200.00")) returns true, so I don't see the point for this question.... — Mar Bar, Dec 10 '15 at 20:09
I can confirm this is a problem for non-US-like localization. I my pc is set with italian locale and decimal.Parse("1200.00") returns 120000, while decimal.Parse("1200,00") returns 1200.00 — lebenf, Mar 13 '19 at 18:20

score 104 · Answer 1 · answered Nov 24 '10 at 08:30

104

Hmm... I can't reproduce this:

using System;

class Test
{
    static void Main()        
    {
        decimal d = decimal.Parse("1200.00");
        Console.WriteLine(d); // Prints 1200.00
    }
}

Are you sure it's not some other part of your code normalizing the decimal value later?

Just in case it's cultural issues, try this version which shouldn't depend on your locale at all:

using System;
using System.Globalization;

class Test
{
    static void Main()        
    {
        decimal d = decimal.Parse("1200.00", CultureInfo.InvariantCulture);
        Console.WriteLine(d.ToString(CultureInfo.InvariantCulture));
    }
}

answered Nov 24 '10 at 08:30

Jon Skeet

1,421,763
867
9,128
9,194

1

Yup and : decimal d = decimal.Parse("1200.000"); Console.WriteLine(d); // Prints 1200.000 so its not a cultural thing. – basarat Nov 24 '10 at 08:33
Vote up, for clarification comments below – Theofanis Pantelides Nov 24 '10 at 08:42
5

Try to change the '.' decimal separator to ','. If the result is different, it is a cultural thing. – Coyolero Jun 05 '14 at 18:38

score 15 · Answer 2 · answered Aug 18 '15 at 09:11

15

Hello i was have the same issue, but it is easly, just do this:

string cadena="96.23";

decimal NoDecimal=decimal.parse(cadena.replace(".",","))

I think this is beacuse the notation that accept C# on decimal numbers are with a ","

answered Aug 18 '15 at 09:11

Adan NetDev

151
1
3

Are you sure? It seems to be dependent on the machine settings. – vCillusion Jun 13 '18 at 08:58
I know this is super old but using a comma instead of a period is more than likely a localization. Some countries use a period and some use a comma for the "decimal point." – TSmith Jun 22 '21 at 19:23

Øyvind Bråthen · Answer 3 · 2010-11-24T08:37:00.087

13

I think your problem is when displaying the decimal, not the contents of it.

If you try

string value = "1200.00";
decimal d = decimal.Parse(s);
string s = d.ToString();

s will contain the string "1200".

However if you change your code to this

string value = "1200.00";
decimal d = decimal.Parse(s);
string s = d.ToString("0.00");

s will contain the string "1200.00" as you want it to do.

EDIT

Seems I'm braindead early in the morning today. I added the Parse statements now. However even my first code will output "1200.00", even if I expected it to output "1200". Seems like I'm learning something each day, and in this case obviously something that is quite basic.

So disregard this a an proper answer. We will probably need more code to identify your problem in this case.

edited Nov 24 '10 at 08:37

answered Nov 24 '10 at 08:30

Øyvind Bråthen

59,338
27
124
151

3

@Øyvind - The `decimal` internal representation stores the decimal place zeros even though mathematically they are irrelevant. So while `decimal.Parse("1200.00") == decimal.Parse("1200")` the `.ToString()` values are "1200.00" & "1200" respectively. The OP doesn't need to specify the decimal places in the `.ToString()` method. – Enigmativity Nov 24 '10 at 08:54
1

@Enigmativity - Thanks for explaining :) This feels like something I really should have known long time back... – Øyvind Bråthen Nov 24 '10 at 09:25

Juan Carlos · Answer 4 · 2021-12-30T15:56:06.753

9

The use of CultureInfo class worked for me, I hope to help you.

    string value = "1200.00";
    CultureInfo culture = new CultureInfo("en-US");
    decimal result = Convert.ToDecimal(value, culture);

edited Dec 30 '21 at 15:56

answered Jun 05 '18 at 04:24

Juan Carlos

131
1
6

score 5 · Answer 5 · answered Nov 24 '10 at 08:30

5

The below code prints the value as 1200.00.

var convertDecimal = Convert.ToDecimal("1200.00");
Console.WriteLine(convertDecimal);

Not sure what you are expecting?

answered Nov 24 '10 at 08:30

Ramesh

13,043
3
52
88

score 2 · Answer 6 · edited Mar 07 '14 at 09:03

2

Use this example

System.Globalization.CultureInfo culInfo = new System.Globalization.CultureInfo("en-GB",true);

decimal currency_usd = decimal.Parse(GetRateFromCbrf("usd"),culInfo);
decimal currency_eur = decimal.Parse(GetRateFromCbrf("eur"), culInfo);

edited Mar 07 '14 at 09:03

slfan

8,950
115
65
78

answered Mar 07 '14 at 08:46

Aleksey Radzhabov

119
1
3

score 2 · Answer 7 · answered Oct 17 '16 at 13:05

Here is a solution I came up with for myself. This is ready to run as a command prompt project. You need to clean some stuff if not. Hope this helps. It accepts several input formats like: 1.234.567,89 1,234,567.89 etc

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Globalization;
    using System.Linq;

    namespace ConvertStringDecimal
    {
        class Program
        {
            static void Main(string[] args)
            {
                while(true)
                {
                    // reads input number from keyboard
                    string input = Console.ReadLine();
                    double result = 0;
                    // remove empty spaces
                    input = input.Replace(" ", "");
                    // checks if the string is empty
                    if (string.IsNullOrEmpty(input) == false)
                    {
                        // check if input has , and . for thousands separator and decimal place
                        if (input.Contains(",") && input.Contains("."))
                        {
                            // find the decimal separator, might be , or .
                            int decimalpos = input.LastIndexOf(',') > input.LastIndexOf('.') ? input.LastIndexOf(',') : input.LastIndexOf('.');
                            // uses | as a temporary decimal separator
                            input = input.Substring(0, decimalpos) + "|" + input.Substring(decimalpos + 1);
                            // formats the output removing the , and . and replacing the temporary | with .
                            input = input.Replace(".", "").Replace(",", "").Replace("|", ".");
                        }
                        // replaces , with .
                        if (input.Contains(","))
                        {
                            input = input.Replace(',', '.');
                        }
                        // checks if the input number has thousands separator and no decimal places
                        if(input.Count(item => item == '.') > 1)
                        {
                            input = input.Replace(".", "");
                        }
                        // tries to convert input to double
                        if (double.TryParse(input, out result) == true)
                        {
                            result = Double.Parse(input, NumberStyles.AllowLeadingSign | NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands, CultureInfo.InvariantCulture);
                        }
                    }
                    // outputs the result
                    Console.WriteLine(result.ToString());
                    Console.WriteLine("----------------");
                }
            }
        }
    }

score 1 · Answer 8 · edited Sep 17 '21 at 10:52

Below code remove spaces/letters and checks culture. No matter decimal separator . or , converts to decimal and returns value.

public decimal convertToDecimal(String str)
{
    // Decimal separator is ",".
    CultureInfo culture = new CultureInfo("tr-TR");
    // Decimal sepereator is ".".
    CultureInfo culture1 = new CultureInfo("en-US");
    // You can remove letters here by adding regex expression.
    str = Regex.Replace(str, @"\s+|[a-z|A-Z]", "");
    decimal result = 0;
    var success = decimal.TryParse(str, NumberStyles.AllowThousands |
        NumberStyles.AllowDecimalPoint, culture, out result);
    // No need NumberStyles.AllowThousands or
    // NumberStyles.AllowDecimalPoint but I used:
    decimal result1 = 0;
    var success1 = decimal.TryParse(str, NumberStyles.AllowThousands |
        NumberStyles.AllowDecimalPoint, culture1, out result1);
    if (success && success1)
    {
        if (result > result1)
            return result1;
        else
            return result;
    }
    if (success && !success1)
        return result;
    if (!success && success1)
        return result1;
    return 0;
}
USAGE var decimal = convertToDecimal(string);

score 0 · Answer 9 · answered Apr 08 '14 at 11:21

0

The value is the same even though the printed representation is not what you expect:

decimal d = (decimal )1200.00;
Console.WriteLine(Decimal.Parse("1200") == d); //True

answered Apr 08 '14 at 11:21

KingCode

858
1
9
9

score 0 · Answer 10 · answered Jul 26 '17 at 08:42

You can try calling this method in you program:

static double string_double(string s)
    {
        double temp = 0;
        double dtemp = 0;
        int b = 0;
        for (int i = 0; i < s.Length; i++)
        {
            if (s[i] == '.')
            {
                i++;
                while (i < s.Length)
                {
                    dtemp = (dtemp * 10) + (int)char.GetNumericValue(s[i]);
                    i++;
                    b++;
                }
                temp = temp + (dtemp * Math.Pow(10, -b));
                return temp;
            }
            else
            {
                temp = (temp * 10) + (int)char.GetNumericValue(s[i]);
            }
        }
        return -1; //if somehow failed
    }

Example:

string s = "12.3";
double d = string_double (s);        //d = 12.3

score 0 · Answer 11 · answered Apr 10 '18 at 09:53

decimal d = 3.00 is still 3. I guess you want to show it some where on screen or print it on log file as 3.00. You can do following

string str = d.ToString("F2");

or if you are using database to store the decimal then you can set pricision value in database.

score -4 · Answer 12 · answered May 12 '15 at 07:44

-4

this is what you have to do.

decimal d = 1200.00;    
string value = d.ToString(CultureInfo.InvariantCulture);

// value = "1200.00"

This worked for me. Thanks.

answered May 12 '15 at 07:44

Dimuthu Ranmal

55
6

Convert string to decimal, keeping fractions

Method 1

Method 2

Method 3

12 Answers12

Linked

Related