回複：dunno how to solve your " ' " problem but

but the dates are all different..
the ' was put in to keep the text from changing into numbers.

but now i want ' to disappear:'(
i try to find and replace 'January with January, but it couldn't find anything ~~>.
do i have to go through each individual cell and delete that manually????

there are hundreds of them:'(

所有跟帖： 

• 原來是這樣哦 -南洋暴雪- ♂ (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