C# DataGridView £ instead of $

Question

I am using a DataGridView to display data from a database. I am trying to format a column to display as a currency with a £ symbol rather than a $.

I am currently using this code:

this.dgvPRL.Columns[4].DefaultCellStyle.Format = "c";

however it displays with a $ not £.

Thank you

score 2 · Accepted Answer · answered Mar 20 '16 at 16:59

If you want to use the current culture currency settings, but change the symbol for that data grid view column, in addition to Format property you need to set DataGridViewCellStyle.FormatProvider property like this (make sure to include using System.Globalization;):

var info = (CultureInfo)CultureInfo.CurrentUICulture.Clone();
info.NumberFormat.CurrencySymbol = "£";
this.dgvPRL.Columns[4].DefaultCellStyle.FormatProvider = info;
this.dgvPRL.Columns[4].DefaultCellStyle.Format = "c";

score 0 · Answer 2 · edited May 23 '17 at 11:45

0

You need to change the current culture.

Check this question: String format currency

edited May 23 '17 at 11:45

Community

1
1

answered Mar 20 '16 at 16:03

Jerry

4,258
3
31
58

Thank you that is very helpful and works with my other variables: but im not sure how to do this for a DataGridView – Besty Mar 20 '16 at 16:54

C# DataGridView £ instead of $

2 Answers2