Numbers - fill down dates for month?

Discussion in 'iPad General Discussions' started by tonyt, Jan 28, 2015.

  1. tonyt

    tonyt
    Expand Collapse
    iPF Novice

    Joined:
    Jan 9, 2015
    Messages:
    15
    Thanks Received:
    0
    Hi
    I have tried all ways! I enter a date - 1 feb 2015, fill down and get 1 feb 2016, 1 feb 2017....
    What I want is 1 feb 2015, 2 feb 2015, 3 feb 2015.....
    Any ideas or help appreciated. I have searched the forum and the manual - no luck so far!
    Cheers
     
  2. silverado8405

    silverado8405
    Expand Collapse
    iPF Novice

    Joined:
    Jul 13, 2013
    Messages:
    47
    Thanks Received:
    11
    First cell enter 1 feb 2015. 2nd cell under the 1st enter 2 feb 2015. Highlight both cells and drag the fill handle. Should fix your problem.
     
  3. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,714
    Thanks Received:
    6,637
    Make sure the first cell is formatted as a Date/Time cell. If it's a text cell then the behavior you're seeing would be normal.

    You can do this either by making sure your enter the information using the Time keyboard, or by changing the date cell's format after the fact by selecting the cell then using the Brush icon's Format tab.

    This the Date Time keyboard.

    ImageUploadedByTapatalk1422510971.315547.jpg
     
  4. tonyt

    tonyt
    Expand Collapse
    iPF Novice

    Joined:
    Jan 9, 2015
    Messages:
    15
    Thanks Received:
    0
    Many thanks both, all sorted! It was the date/time format that did it!
     
  5. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,714
    Thanks Received:
    6,637
    No problem. Glad to help.
     

Share This Page


Search tags for this page

numbers fill date by month