How do I enter the date easier? 3

[JohnnyT]

Hi

I have a worksheet that has a 'date' column. I wondered if there was anyway of making Excel popup a date picker if I click on the cell.

Its a pain to have to keep typing 01/07/07 , 14/07/07 etc etc

I've searched on Google and on Office Online but couldn't find anything.. it seems like such a common task though that I'd be surprised if they hadn't come up with an easy way of doing it.

Many thanks for your help

All the best

John

I don't make mistakes, I'm merely beta-testing life.

 

[SkipVought]

Hi,

There is one, but it takes VBA Code to make it work.

Why key in the leading ZERO? Save yourself some grief!


Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[SkipVought]

faq68-5827

Also, if the year is the CURRENT year, just key in the day slash month

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[JohnnyT]

Skip

Thanks for the tips.. didn't know that you didn't need to type the year.

Cheers

JT

I don't make mistakes, I'm merely beta-testing life.

 

[Zathras]

If it's just today's date you want, you can simply type Ctrl+; (Control and semi-colon together.)

Shift+Ctrl+; enters the time.

 

[JohnnyT]

Zathras

Thanks for the tip but I'll be entering the dates retrospectively at the end of the month.

I'll bear it in mind though for other excel projects

Cheers

JT ;-)

I don't make mistakes, I'm merely beta-testing life.

 

[fneily]

See:
A Pop-up Calendar for Excel

http://www.fontstuff.com/vba/vbatut07.htm

Users like this.

 

[mintjulep]

Easier for who?

For any half-way decent keyboarder, data entry clerk or what we used to be able to call secretaries it is far faster to type in a date than it is to take your hands off the keyboard, click to activate a pop-up, click to navigate to the desired date and then click or tab to the next cell.

 

[PeterMoran]

Hi,

For quick date entry checkout Chip Pearson's great website at:

http://www.cpearson.com/excel/DateTimeEntry.htm

This will enable you to enter the date without the slashes.

Chip has set this up for US dates (mm/dd/yy) - if that is not suitable I have modified code for (dd/mm/yy).

Good Luck!

Peter Moran

 

[JohnnyT]

PeterMoran, fneily

Thanks for your suggestions. I'm going to use fneily's pop up suggestion as this best suits my needs and it also gives me the ability to type a date if I want or to pick it from a pop up box.

Brilliant stuff!

A big thank you to you all.

Cheers

JT ;-)

I don't make mistakes, I'm merely beta-testing life.