How to maintain leading zero in date field.
Posted on 2014-03-27
I have to export an Excel worksheet to a CSV file with one of the columns containing date information in the format of MM/DD/YYYY.
I have the correct format and then I change the column to text, but it still messes up any dates that being with 0 for the month, for example 02 for February.
How can I maintain the 0's? The upload simply fails as of now, or at least 850 entries do. I'm using Excel 2007, but I do have 2010 available if I need to use that instead.
I'm uploading student information into a state system.
Thanks for any help,