4 Apr
2022
4 Apr
'22
7:25 a.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.
- 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?