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: 460
mac
|iwork-numbers
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