Date

Hi Ko Be,
Diligently I'm attempting to understand what is you're desired outcome is to be, but, I'm not completely sure. Would you be so kind as to further explain exactly what your wanting, and show the exact outcome you expect.

Using your example: In the cell formated as date only cell, when I enter the number, 5, it returns 01/03/04.

I look forward to your reply.

Sincerely,
RicD

I think what Ko Be is implying is that he can enter the day number adn the program assumes the current Month and year. Am i right Ko Be?

If so, than no, you can make it create the date in a nother cell next to it by using the following equation (lets assume you enter 5 into A1)
b1=date(year(today()),month(today()),a1)

Hope this helps some,

Jason

If you restrict yourself to the current month, perhaps it can be done by extracting month and year from TODAY() and then reconstructing the date from that with the keyed entry for the day of the month.

Don't you hate it when someone posts exactly the solution you have just come up with, WHOLE you are still typing it in? Then you don't see it until after you post the same thing....

sorry man, Happens to me all the time too.

Jason

Sorry, but your answer is not helpful. The Original Post asked a user interface (data entry) question. When I use Excel to enter data into a cell which is already formated with a date format, it understands that I want to enter a date and assumes the current month and year. Thus it is very efficient, minimizing the typing required for entering dates.

Sure we can add cells, columns and formulae to a table to separate the data we use (calculated) from the data we enter (the "5"), but that is truly a very ugly complication. All that was asked for was, how can I efficiently enter dates with retyping (or calculating) repetitive parts.

I don't know the answer, unfortunately. Apple has a great reputation for user interface coolness, but Numbers is starting to look very much like a not-quite-there-yet product.

Hello

OK, a single 5 is not sufficient.

Type two more chars is sufficient

5/8
give
05/08/2007 00:00:00 on my french system.

Yvan KOENIG (from FRANCE dimanche 26 août 2007 16:13:43)

I have not found any way to do it with just the date, however, date and month should be enough. Year is not needed.

I guess it depends on date formats, but just typing "5/8" gives "05/08/2007 00:00" on my British English system.

Hello

I get the seconds because I set the date/time format to do that.
As the entry is just a date, it would be better to select a "date only" format "dd/mm/yyyy" for instance.

Yvan KOENIG (from FRANCE dimanche 26 août 2007 17:10:10)

Slightly off topic but does any one else just get "current date and always 12:00AM" when asking to insert date and time

Hello

Insert date/time correctly insert the current date/time.

About the used format, look in the Help.

There is a chapter about that.
Translated from french, the title may be:
"Insert page numbers and other variable values"

Yvan KOENIG (from FRANCE lundi 27 août 2007 08:12:17)

I also always get 12:00AM. John did you find a solution to the problem?

J&A - no I didnt find a solution. Time for a bug report.
Also if I control click the field (as suggested by the help) nothing happens .

I get the expected result if I insert into a text box.

I suspect the more people report it further up the list of priorities it goes.