[RESOLVED] How to make Listview not to truncate trailing zeroes after decimal

Hello,

I made a program to import data from Excel spreadsheet.

It seems everytime datas with trailing zero will be truncated.

For eg.

1245.60 will turn out as 1245.6
1245.61 appears ok - 1245.61
1245.00 - 1245

I want 1245.00 and 1245.60 to turn out as it is.

Thanks,

well the listview only displays strings, so it's not the listview that's truncating the trailing 0, but rather most likely your code that's reading the data... even still when you add it to the listview, just use Format$ to format it to the correct display value.

-tg

Found the solution - Format Cells in the source excel file to Text or make it non formatted.