请问个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