How do I enter a date without using slashes or dashes?

S

Sue Miller

I want to be able to enter, for example, "030107" and have the cell formatted
so I get 03/01/07.
 
D

Don Guillett

You can use a worksheet_change event that converts your text entry to the
date entry automatically. I did this for a client a few days ago.
 
N

Niek Otten

Hi Don,

Quite possible. But I don't know if the OP knows how to implement that, and this utility requires no knowledge of VBA.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Niek,
|
| Wouldn't a worksheet_change event involve less overhead?
|
| --
| Don Guillett
| SalesAid Software
| [email protected]
| | > Look here:
| >
| > http://xldynamic.com/source/xld.QDEDownload.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |I want to be able to enter, for example, "030107" and have the cell
| > formatted
| > | so I get 03/01/07.
| >
| >
|
|
 
Top