Thanks for that tool. 2 years on and it is still useful.

Toby

"CyberTaz" wrote:

Do you need to retain the dates as values for calculation purposes? If *not*,
try using the Custom Format: 00"/"00"/"0000

Regards |:)

"Smurfoz" wrote:

When entering a date in Excel what format should be used to allow the user to
only key the actual characters. For example, we want to key in 17102005 and
would like this to show in the cell as 17/10/2005. We are having problems
with this