I would do that, but they'll find all kinds of ways to enter a date and then
will complain if we ask them to enter the / / . I thought there was a way to
enter six numbers and Excel would format for me.

"Dave Peterson" wrote:

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