[Solved] Help changing the data type of cells on a datagridview

See more:

C#

WinForms

DataGridView

Hi.
I am trying to load some information from a query into a datagridView.
This query return an integer and some decimals.

After loading the information into the DataGridView , I need to take that first number and format it ( it is a date, so I change it from (int) yyyymmdd format to (string) dd/mm/yyyy , but the datagridview seems to ask for an int32 ValueType.

I tried to change the Cell ValueType to String type. After changing it (and checking if it really is string type now) it still asks for an int32 format value.

Any idea of what is happening?

DG.DataSource = //Function giving a data table             
DG.Columns[0].ValueType = typeof(String);
for (int i = 0; i < DG.Rows.Count; i++)
{
    string a = //Function returning date format string, dd/mm/yyyy
    DG.Rows[i].Cells[0].Value = a;
}

UPDATE:
Resolved by OP himself. Posted the answer as one of the solutions below.