Change date format in Numbers 3.2

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.


Solution 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 hereenter image description here