Why is Excel removing leading leading zeros when displaying CSV data?
- by Velika Kudac
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a number without a leading 0.
When I format rows 2 through 4 as "Text", it changes the display to
...but still the leading "0" is gone.
Is there a…