to set the date format
use Replace function to replace ' , and the use the format funct
所有跟帖:
•
這個我也試了,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