I have a table with US dates. how can i sort correctly? my mac is set up with Australian date format. i tried changing to US format in system prefs but when i return to Numbers the date formats are still all Australian.
Numbers '09-OTHER, Mac OS X (10.7.5)
If the values in this column are true Date and Time values, they should sort correctly no matter what format you have chosen to display them.
If they are text, then they will not be affected by any change in the Date and Time format set for the cells containing this date, and will sort as Text values.
To check the value in, say, cell B2, enter the formula below into any available cell on the table. The result will be the date one day later if there's a Date and Time value in B2, and an error message, "The operator "+" expects a number, date or duration, but cell B2 contains a string," if the data in B2 is being interpreted as a text string.
=B2+1
Regards,
Barry
DH,
I'd suggest that you look for a Date Format that is common to both localizations. Pick a format that has no chance of ambiguity and you should be in good shape. Here are the American English options on my system. I'm not sure if this is the default list because I have a faint recollection the Yvan Koenig posted, years ago, a technique for adding formats to the menu and I may have added one or two.
Regards,
Jerry
US to Australian date conversion?
