Maybe you could just format the cell the way you like (mm/dd/yy).

Then use data|validation to make sure that they enter a date.



Teri wrote:

I am creating a spreadsheet for non-Excel users. If I tell them to enter a
date, I'll see it fifteen different ways. I want to instruct them to enter
the date as xxxxxx. In other words, October 3, 2006 would be entered at
100306, but I want it to display 10/03/06. How can I do this?

--

Dave Peterson