Re: Converting dates




Assuming A1 contains your date.

=TEXT(A1,"yyyymmdd")


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15310
View this thread: http://www.excelforum.com/showthread.php?threadid=464268

.