4 Apr
2022
4 Apr
'22
1:25 p.m.
Examples: * LibreOffice Calc * Microsoft Excel
Double quotes are only required for parsing, they are not used to judge if the input is a string or number. A little example: 1;"1" If you save this one-liner as CSV file and open it with Excel, but values will be interpreted and formatted as numbers.
3. What would be the determining factor for using double quotes? A specific data type indication should occasionally be applied for texts.
I can’t follow, sorry. Examples might help. Maybe the issue you want to solve is a non-issue? How can we reproduce the problem you encountered with Excel?