Listview in VBA - amouting is not pulling with format

The amount is not pulling in listview with proper format. Eg: If I enter 1,00,000 then listview is showing as 100000. Can you please assist me

I just want to show the commas in my amount.

Answers


Listview controls only accept text. If you add something that's not text, it converts it however it sees fit. If you want to format a number or date to display a certain way, you have to format it yourself.

lvItem.ListSubItems.Add Format$(10^6,"#,###,##0")

Need Your Help

Add and read Multiple textboxes

c# winforms

What is the best way to create and read multiple textboxes in a windows form? In my application, I have a windows form where customer can enter multiple addresses, email addresses