Link to home
Start Free TrialLog in
Avatar of Ernesto
ErnestoFlag for Mexico

asked on

format a s currency ittem in a listview

hi all
how do i format as a currency

 lv.SubItems.Add(objRead("monto").ToString)

tsm
Avatar of it_saige
it_saige
Flag of United States of America image

Use the C2 string format specifier; e.g.:
Public Class Form1
	Private objArray(5) As Object

	Private Sub OnLoad(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
		objArray(0) = 123.0
		objArray(1) = 57.34
		objArray(2) = 67
		objArray(3) = "NaN"
		objArray(4) = 58
		objArray(5) = 0.05

		Dim tempVal As Decimal
		For Each item In objArray
			lv.Items.Add(If(Decimal.TryParse(item, tempVal), tempVal.ToString("C2"), "Not a number"))
		Next
	End Sub
End Class

Open in new window

Produces the following output -User generated image-saige-
Avatar of Ernesto

ASKER

lv.SubItems.Add(objRead("monto").ToString("C2", CultureInfo.CurrentCulture))

do not work
ASKER CERTIFIED SOLUTION
Avatar of it_saige
it_saige
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ernesto

ASKER

Man!!!!
tsm
your a %$#$%#$% Genious!!