Paste string of date format mm/dd/yy to Numbers
- by David.Chu.ca
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into Numbers. For example:
04/01/10
04/03/10
04/13/10
The result will be:
2004-01-10
2004-03-10
04/13/10
It looks like that Numbers convert the mm into year, then month and last day. Is there any way to paste whatever as they are? Do I have to change settings in Numberers or System preference?