Hi Keith,

The easiest thing todo is to turn on data validation which will only allow
them to enter a date in the correct formas (either 23/10/06 or 23-10-06)

HTH

Simon

Keith wrote:
I have a spreadsheet that contains a column for the date. Some users input
the date as: 23/10/06, some as 23.10.06 some as 231006 and some as 23-10-06

Is there a way that no matter how they enter it, it will be accepted and
converted to the 23/10/06 version?

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com