2 cases for CSV how excel picks up and formats text
top - windows culture
left - text
right- excel
excel picks up that 12/02/2012 is a date and chops of YY from the year
2012-02-14 is recognized as a date and chops of YY from the year
15-Feb-2012-chops of YY from the year
2012/02/16 converted to default
22-12-2012 converted to default
here is more:
I have no idea why these things happen
No comments:
Post a Comment