How to turn off auto-reformatting of dates?

I recently upgraded to iWork '09.

I have a files saved from prior versions of Numbers. I happen to format my dates as:

YYYY-MM-DD

It is the manner I prefer as it keeps them chronological when I sort (not specific to Numbers, but just in general -- for instance, folder names and such). I always write my dates this way and prefer that they stay this way.

Now, when I open my Numbers files in iWork '09, it keep pre-existing cells in the date-format as I have them, but when I try to add a new cell, and I type the date in as, for instance, "2010-02-07" and I tab or select to the next cell, it auto-reformats the cell to read, "Feb 7, 2010".

I cannot find any way to turn this off.

The file I happen to be working on goes back several years. I don't want new date fields to suddenly switch from my preferred formating to this new formating beginning this week.

Thank you for any assistance in turning off this new "feature."

Thanks.

2 Primary Machines: 17" MacBook Pro, 2.93 GHz Intel Core 2 Duo / Dual 2.7 GHz Power PC G5, MBP is running OS X 10.5.8 / G5 is running OS X 10.4.11

Posted on Feb 7, 2010 3:02 AM

Reply
5 replies

Feb 7, 2010 12:23 PM in response to Chris Grayson

Another option is a custom format that displays dates as YYYY-MM-DD. You can type them in that way or type them in in any other acceptable date format, like 1/2/2010 and they'll display as YYYY-MM-DD.

What I would suggest is to determine how the pre-Numbers '09 cells were formatted and do the same for the new cells. What you don't want is for some to be one way and some to be another. Numbers will sort actual dates separately from text that looks like a date. If there is a mix, they may not end up in chronological order.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to turn off auto-reformatting of dates?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.