Excel VBA ListView format to display Decimal values with comma

Hello,

Hope you can assist with solving this:

I would like to make the Price column in the ListView display the values with the 3 digit comma separation and ending with 2 decimal places (#,###.00)

I had tried many ways that I found online, but due to the format in which my code add the items in the listView, I am unable to figure out how to achieve this.

Thanks a lot

Please Login or Register  to view this content.

Either use the cell TEXT property to add the formatted displayed value from the cell or else use use the FORMAT function for each individual Subitem you want to format.

Thanks for your reply cytop,

Could you please clarify no how to go about doing it with ref to my code?

I tried using the following code as FORMAT function for each Subitem but couldn't get it to work:

ListView1.ListItems.SubItems(4) = Format(Expression, "#,###,##0")

Please advice.

Thanks

You have to format each subitem as it is added to the ListView, probably in the 'For Lngsub...' loop. Using a phone so not really going to try and write code.