chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005
 

If the excel recognises your entry above as a date, you simply have to go to
Format Cells custom and enter the format:
mm/dd/yyyy

whereas, if excel is treating your entry above as text, and supposing your
entry is in cell A1, then use the following formula:
=DATEVALUE(RIGHT(A1,(LEN(A1)-FIND(" ",A1))))
and then format as mentioned above.


Mangesh



PS: People here appreciate a message body instead of a subject only.





"Jonny1975" wrote in message
...