Benches Uncategorized

5

How to turn off auto-reformatting of date…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

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.

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    D'Fish'N'Seas

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You can change the cell format from "automatic," to "number" or "text," and that should leave it the way you type it.

  2. 0

    Chris Grayson

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you.

  3. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  4. 0

    D'Fish'N'Seas

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Nice. Thanks!

  5. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    An other soluce is to edit the resource file describing the formats which may be used to display dates.

    Remove the mm-dd-yy one (as well as the numerous variants) and replace them by formats matching the IEEE format.

    This may be done for iWork '08 as well as for iWork '09.

    Yvan KOENIG (VALLAURIS, France) dimanche 7 février 2010 23:02:50