Select the column(s)
Right-Click
Format Cells...
(new window)
Number
Date (select your preferred format)

If the format you want does not appear, goto
Custom
In the type box, key in your format, (yyyy-mm-dd) will format the date
as 2006-05-28


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546126