You could try formatting the cells by going into "format", "cells", then
down to "custom". If you type "yyyymmdd" (without the quotes) into the
Type box (it will probably default to "general") and then enter 6/20/06
into that cell it will display as 20060620. If you need "/" marks make
the format type "yyyy/mm/dd", enter 6/20/06 into the cell as a test,
and you'll get 2006/06/20.

You can enter your information as 6/20/06; June 20, 2006; or June 20,
and the you'll get the same displayed result -- either 20060620 or
2006/06/20.


--
JennieJ
------------------------------------------------------------------------
JennieJ's Profile: http://www.excelforum.com/member.php...o&userid=35576
View this thread: http://www.excelforum.com/showthread...hreadid=554749