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

请您先登陆,再发跟帖!