I have a csv file that, in the editor, shows a field with leading zeros, i.e. “072931”
but that field is displayed in calc as 72931
even if I have Format/cells Leading zeroes 1
How can I make calc display the leading zeroes?
Actually, the “” indicate this is a character field, why are the leading zeroes removed?