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.
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.