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

"Don Guillett" wrote in message ...
| Niek,
|
| Wouldn't a worksheet_change event involve less overhead?
|
| --
| Don Guillett
| SalesAid Software
|
| "Niek Otten" wrote in message
| ...
| Look he
|
| http://xldynamic.com/source/xld.QDEDownload.html
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Sue Miller" <Sue wrote in message
| ...
| |I want to be able to enter, for example, "030107" and have the cell
| formatted
| | so I get 03/01/07.
|
|
|
|