in reply to Formatting a csv column as 'number'
This sounds like an Excel problem to me, for example if you create a text file containing:
'0100',"0100",0100
Open it in Excel then save it. You will see that anything Excel thinks could be a number (or a date, or fraction, or whatever) it treats as one and messes up accordingly.
It makes some jobs that should be simple a real pain
In Section
Seekers of Perl Wisdom