I recently updated Numbers to 3.2.

I want to be able to put a date in a cell numerically (8-22-14) and then have it show up with the month name, day, and year (August 22, 2014) without having to do a formula. I do not need the time.

1 Answer 1

  • Click the Format button in the upper right
  • Select the "Cell" tab
  • Under Data Format select "Date & Time"
  • Under Date select your prefered format.

You should be able to enter a date in these newly formatted cells any format (like 8-22-14) and it should change to your selected format.

enter image description here enter image description here

  • This doesn't actually work for me. I paste a date in from a properly-formatted cell, and it says "automatic" in the format. When I set it to date & time, it just changes it back to automatic when I leave and reenter the cell.
    – Almo
    Commented May 8, 2016 at 18:21

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .