In MS Excel, I always select
delimiter = Comma
text qualifier = "
for example in csv file there are many commas like 58,073,560.23
StringGrid1.LoadFromCSVFile(OpenDialog1.FileName,',',true)
csv file ....
I t e m , D a t e , Q u o t a t i o n N o , A m o u n t
0 1 , 0 5 / 0 5 / 2 0 1 2 , Q T T 2 3 9 , " 3 , 6 2 4 , 9 9 7 . 3 1 "
StringGrid1 ...
I t e m D a t e Q u o t a t i o n N o A m o u n t
0 1 0 5 / 0 5 / 2 0 1 2 Q T T 2 3 9 3 , 6 2 4 , 9 9 7 . 3 1
It shows 1 character in 1 cell.
What should I do to solve this probem ?
Thank you in advance ...