Teri

If you want it done while entering see Chip Pearson's site for code.

http://www.cpearson.com/excel/DateTimeEntry.htm

If you want them to enter the numbers and deal with them later, use

DataText to ColumnsNextNextColumn Data FormatDateMDYFinish


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 13:41:02 -0700, 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?