You can set the format via the DataGrid CellStyle property.
https://msdn.microsoft.com/en-us/library/system.windows.controls.datagrid.cellstyle(v=vs.110).aspx

I can show a sample little later but working on a project for now and hoping this helps you until someone else jumps in.

You can the same in SQL and .net

Cast or Format column...

SELECT
CAST ( ColumName AS BIGINT )
From yourtable

select cast (21.2432 as int )
select format(21.2333 ,'#')

.Net..

  Int(lnumber)
ToString("column")

Hi, instead of changing it on datagridview, since I want to display it in label, I put this code to round off the value but I need a separator for a value ( , ) comma.

Example 5900 make it 5,900

        conn.Open()
        Dim rd = cmd.ExecuteReader
        If rd.Read = True Then
            Label60.Text = rd(1).ToString()
            myDA.Dispose()
        End If

        Dim a As Single
        Dim b As Double = Convert.ToDouble(Label60.Text)
        a = Math.Round(b)
        Label60.Text = a & " MB"
        conn.Close()

Select allOpen in new window

Please try this -

Format function ..

Format( a , "c")

Where is the Php came from? :)

try printing your column with and without format .

        Dim a As Single
        Dim b As Double = Convert.ToDouble(Label60.Text)
        a = Math.Round(b)
        Label60.Text = Format(a, "c") & " MB"

Select allOpen in new window

Is "C" stands for currency?

Ooooo I got it!

        Label60.Text = Format(a, "0,000") & " MB"

Select allOpen in new window

Cool...format .!!