You cannot format a cell to do this.
Chip Pearson's site has event code that will look after the change as you enter
the numbers.
http://www.cpearson.com/excel/DateTimeEntry.htm
Gord Dibben MS Excel MVP
On Mon, 11 Sep 2006 13:52:02 -0700, Stover
wrote:
I would like to format a cell so that I can just type in the numbers in a
date and have the cell display the date with the forward slashes added
automaticly! Example type in only 040906 and have Excel display 04/09/2006
in the cell.