Paste a list of dates in format of "mm/dd/yy" to iWork-Numbers

Posted by David.Chu.ca on Super User See other posts from Super User or by David.Chu.ca
Published on 2010-04-23T02:05:43Z Indexed on 2010/04/23 3:03 UTC
Read the original article Hit count: 423

Filed under:
|

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?

© Super User or respective owner

Related posts about mac

Related posts about iwork-numbers