String.Format Same Code Different View

Question

I have a code like this;

GridView1.FooterRow.Cells[11].Text = String.Format("{0:c}", sumKV)

In my computer this code gives a result like that;

But when I upload this code to my virtual machine it looks like this;

TL means Turkish Liras. But I don't want to show the currency. I just want numbers.

I also don't want to change the formating of numbers. (Like 257.579,02)

How can I only delete TL in this code?

Answer 1

I would use this:

var cultureWithoutCurrencySymbol = 
    (CultureInfo)CultureInfo.CurrentCulture.Clone();
cultureWithoutCurrencySymbol.NumberFormat.CurrencySymbol = "";
GridView1.FooterRow.Cells[11].Text = 
            String.Format(cultureWithoutCurrencySymbol, "{0:c}", sumKV).Trim();

Background:
This will still keep the currency formatting for the current culture, it just removes the currency symbol.
You can save this special culture somewhere, so you don't have to create it every time you need to format your values.

UPDATE:

• Now it even compiles... ;-)
• Added a Trim(), because there is still a space after the formated number.

Answer 2

Another option is to turn off the currency symbol entirely for the current thread:

private static NumberFormatInfo SetNoCurrencySymbol()
{
    CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();
    NumberFormatInfo LocalFormat = (NumberFormatInfo)NumberFormatInfo.CurrentInfo.Clone();

    NumberFormatInfo ret = culture.NumberFormat;

    LocalFormat.CurrencySymbol = "";
    culture.NumberFormat = LocalFormat;

    // Add the culture to the current thread
    Thread.CurrentThread.CurrentCulture = culture;

    return ret;
} 

That way you will change less code. You can always change it back afterwards:

 NumberFormatInfo origNumberFormat  = SetNoCurrencySymbol();

 string x = String.Format("{0:c}", 55);

 CultureInfo.CurrentCulture.NumberFormat = origNumberFormat;

 string y = String.Format("{0:c}", 55);

Answer 3

Because you are using String.Format with a format string only, sumKV is formatted according to the UI Culture actually used in your application.

GridView1.FooterRow.Cells[11].Text = String.Format("{0:c}", sumKV),

To get rid with currency symbol, use InvariantCulture in String.Format this way :

String.Format(CultureInfo.InvariantCulture, "{0:c}", sumKV);

Answer 4

If you don't want to show currency then don't use the currency formatting code - {0:c}. Perhaps try something like the following:

GridView1.FooterRow.Cells[11].Text = String.Format("{0:G}", sumKV);

See this article - String.Format doubles