use Replace function to replace ' , and the use the format funct

to set the date format

所有跟帖： 

• 這個我也試了，replace doesn't work for ' somehow -南洋暴雪- ♂ (0 bytes) () 06/19/2007 postreply 14:40:10

• =right(A1,10) -不提也罷- ♂ (0 bytes) () 06/19/2007 postreply 16:06:14

• or copy to Word, and use Replace in Word. -不提也罷- ♂ (0 bytes) () 06/19/2007 postreply 16:07:17