Skip navigation

Unwanted automatic fill-ins in Numbers Spreadsheets

324 Views 7 Replies Latest reply: Dec 19, 2012 1:39 PM by Niku RSS
Niku Level 2 Level 2 (285 points)
Currently Being Moderated
Dec 17, 2012 12:16 PM

I'm making a simple list of songs. To make it a bit more interesting, I'm adding YEAR, and TIME (song duration). The problem I'm having is that whenever I type the duration of the song, Numbers takes over and adds "AM" to the time. I've  tried changing the column header to "Min/Sec" and "Duration" but "AM keeps being added. How can I eliminate this unwanted addition? Deleting "AM" only makes it worse. I then get the day of the week, and the month, day and year added.

iDVD 7.1.1 (1150)
  • Wayne Contello Level 6 Level 6 (12,670 points)
    Currently Being Moderated
    Dec 17, 2012 12:56 PM (in response to Niku)

    I would actually enter the duration in the duration format...


    instead of entering, for example, "6:21" enter "6m 21s".


    Oh... and I would preformat the cells a "Duration"

  • Wayne Contello Level 6 Level 6 (12,670 points)
    Currently Being Moderated
    Dec 17, 2012 3:22 PM (in response to Niku)

    preformatting was short hand for ... select the cells you want formatted a a duration, select the duration format from the cells inspector before entering data... that's it.  nothing special.


    I hope this helps

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Dec 18, 2012 10:18 PM (in response to Niku)

    Hi Niku,


    Nothing really strange about it—Numbers, unlike many spreadsheet applications, recognizes there is a difference between "Time" (a specific instant in history, which includes representation of a date and the time of day on that date), and "Duration" (the amount of 'time' that has passed between two events, or between the beginning and end of a specific event.


    Regarding 'pre-formatting' cells as Duration:


    Select the the column that will contain the length of each item in minutes and seconds.

    Open the Inspector, choose the Cell Format Inspector (42), then select Duration from the pop-up menu.

    Picture 11.png

    After this selection, use the sliders to set the units to minutes and seconds, and the format to one of the three shown.

    Picture 12.png

    Then enter the length of each piece into the formatted column, using the formay you'e chosen.

    Picture 13.png




More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.