請問個excel的問題

i copyed a column of date into another new worksheet, but the date is formatted in the original as "'January 15, 2007", with a ' in front. and i want to formate the date as 01/15/2007, but i can not format it w/o go to each cell to delete the ' in front. but since there's like hundrends individual cell, i want to just use the "format painter" for the whole column, is there a way to do this? thank you!

所有跟帖： 

• dunno how to solve your " ' " problem but -南洋暴雪- ♂ (96 bytes) () 06/19/2007 postreply 14:02:00

• 回複：dunno how to solve your " ' " problem but -daisykk- ♀ (357 bytes) () 06/19/2007 postreply 14:05:06

• 原來是這樣哦 -南洋暴雪- ♂ (286 bytes) () 06/19/2007 postreply 14:16:21

• ohh.. thanks:) 可是因為裏麵有數字也有ｔｅｘｔ，也可以定義為ｔｅｘｔ嗎 -daisykk- ♀ (0 bytes) () 06/19/2007 postreply 14:28:40

• ＂１４４５６６＂　也是text 不是嗎 -南洋暴雪- ♂ (0 bytes) () 06/19/2007 postreply 14:30:37

• >.<還是不行啊，還是要一個一個改阿~~~>.<~~~ (圖) -daisykk- ♀ (378 bytes) () 06/19/2007 postreply 14:33:19

• sigh... -南洋暴雪- ♂ (130 bytes) () 06/19/2007 postreply 14:34:46

• 可是在text2col.看不到那個＇號． -daisykk- ♀ (187 bytes) () 06/19/2007 postreply 14:47:12

• 我試過了，一定可以的 -南洋暴雪- ♂ (41 bytes) () 06/19/2007 postreply 14:39:34

• forget to tell you, highlight the whole column...... -南洋暴雪- ♂ (0 bytes) () 06/19/2007 postreply 14:45:43

• got it~ thank you so much! -daisykk- ♀ (0 bytes) () 06/19/2007 postreply 14:56:22

• use Replace function to replace ' , and the use the format funct -不提也罷- ♂ (22 bytes) () 06/19/2007 postreply 14:34:46

• 這個我也試了，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

• 回複：請問個excel的問題 -珠峰- ♂ (123 bytes) () 06/19/2007 postreply 19:16:38

• 用right或者left，看一下help -YumenIT- ♂ (0 bytes) () 06/19/2007 postreply 21:56:23