Help me to format currency col(2) = 1.234.567
I have search any where can'not find answer

With Lv1
                .Clear()
                .View = View.Details
                .FullRowSelect = True
                .GridLines = True
                .Columns.Add("Product Name", 250)
                .Columns.Add("Stock", 90, HorizontalAlignment.Right)
                .Columns.Add("Price", 90, HorizontalAlignment.Right)
                '.SubItems(2) = Format(Value, "#,##0.00")           
                FillListView(Lv1, GetData(sSql))
            End With

tx

Recommended Answers

All 9 Replies

Help me to format currency col(2) = 1.234.567

What that mean 1.234.567 ?

Try this

Dim money As Double = 12.34
        Dim euro As String = money.ToString("c", New Globalization.CultureInfo("fr-FR", False))
        MsgBox(euro)

Service Unavailable

Dim money As Double = 12.34
    Dim euro As String = money.ToString("c", New Globalization.CultureInfo("fr-FR", False))
    MsgBox(euro)

this only show msgbox 12.34 ---------------------------
Inventory
---------------------------
12,34 €
---------------------------
OK
---------------------------
1.234.567 = I want my listview colom format like this.

my lv1

ProductName_Quantity_Price
product01___1000___10000
product01___1200___15000

I want display with format
product01___1.000___10.000
product02___1.200___15.000

In which currency two points (.) exist ?

cannot,
listbox and dgv not listview

dim money

Inventory
---------------------------
12,34 €
---------------------------
OK

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.