Tuesday, December 4, 2012

Excel-CSV Date Issues



What happens when you save the following s/sh to csv?


The first column is formatted mm-dd-yyyy  (jan-2 ), the second dd-mm-yyyy(feb-12 )

The answer: 12-02-2011,12-02-2011

No comments:

Post a Comment