First, make sure what you have in your cell is truly an "Excel Date"
(which is a number that Excel interprets as a date) by changing the
format of the cell to General. The cell should now show the "Date
Number" of 38590.63819 (or similar). If it still shows "8/26/2005
3:19:00 PM", then what you have is a TEXT entry and changing the format
will not alter it.
What do you find?
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=475984