Wednesday, March 21, 2012

Formatting numbers

I have a column in a dataset and i would like to change the number format of the column so that it has comma's separating the thousands place.

Hi,

Function Fixbigint(lng as long) as string
Dim nfi As System.Globalization.NumberFormatInfo = _
New System.Globalization.CultureInfo _
("en-US", False).NumberFormat
' lng=9223372036854775807
nfi.NumberGroupSeparator =","
return lng.ToString("N", nfi)
end function

s it any useful.

kiki


|||

Is that for Sql.

|||

NVM i figured it out again.Sleep

No comments:

Post a Comment