Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address

The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

auto format problem in numbers

So, I am making a spreadsheet with 2019 sales/expenses etc... but the format option for auto filling cells with dates - or completing it when i type in partial like mar 14 should become march 14 2019 but it won't let me. It fills in 2020... I see no way to correct that. The auto options are all 2020... I shouldn't need to make the whole computer believe it is 2019 just to have the date for one column be 2019... am i missing something. The image shows the drop down for date under date & time<format. No place to choose or manually set dates

MacBook Pro 13", macOS 10.14

Posted on Jan 17, 2020 12:12 PM

Best reply

SGIII

Level 8

35,426 points

Posted on Jan 17, 2020 11:55 PM

Numbers is giving you a chance to select the format you want. It doesn't "autofill" with the date. You need to enter the actual date in a cell. Type 2019 in the date you enter if that is the year you intend. If you leave out the year when you enter a date Numbers will guess that you mean the current year (now 2020). The date you enter in a cell will be formatted using your selection for Data Format.

View in context

auto format problem in numbers

Similar questions