Paste a list of dates in format of "mm/dd/yy" to iWork-Numbers
- by David.Chu.ca
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into iWork-Numbers. For example, I have a list of strings(text in VIM):
04/01/10
04/03/10
04/13/10
I copy those strings and then paste into my iWork-Numbers worksheet. The result will be:
2004-01-10
2004-03-10
04/13/10
It looks like that Numbers (mac workseet application in iWork) tries to convert the first two digits into year, then the next two into month if less than 12 and last two digits to a day, for the first two rows. For the third(04/13/10), since the middle two digits are 13 and cannot be a month, then this row is pasted as it is (actually it is what I need).
Is there any way to paste whatever as they are, without any "smart date conversion"? Do I have to change settings in Numberers or Mac OS's System preference?