1 Reply Latest reply: Nov 16, 2012 10:34 PM by Barry
papatomal Level 1 (0 points)

First visit to Apple Support Communities - I have downloaded data from financial institution which includes the date formated, for example, Nov 6, 2012 after the spread sheet is opened with Numbers.  Using the inspector > cell > date > format "01/05/09 " , the cells in the spread sheet with the dates all become "01/05/09" . . .  and not "11/06/12".


I am concerned that I have set up a bad templete dictating this erroneous result and would like to delete the templete.  Please advise on this point.


Any other suggestions would be welcomed.

iMac, OS X Mountain Lion (10.8.2)
  • Barry Level 7 (29,976 points)

    Hi papa T,


    I doubt that a 'bad template' is the cause of this strange issue.


    Leaving that aside, here is the path to deleting templates that you have created and saved:


    Close Numbers. Go to the Finder.


    In the Finder, press the option key, go to the Go menu and choose Library.


    This puts you in your user Library—note that OS X maintains several Libraries, one for itself and one for each user account on the computer.


    From your Library, open:


    Application Support > iWork > Numbers > Templates > My Templates.


    In My Templates, select one or more templates, then press command-delete to move the selected templates to the Trash.


    Empty the Trash to permanently delete these templates (and anything else that has been moved to the Trash).