Select the cell(s) you want to format.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Date or Time, and then click the format you
want to use.
Note If you don’t find what you’re looking for, you can create a
custom number format by using format codes for dates and times. (taken
from excel help)

You Don't have to convert any of the date-time values, just change the
cell formatting to change how they are displayed.

hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=489790