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

請您先登陸,再發跟帖!