回复:dunno how to solve your " ' " problem but

回答: 请问个excel的问题daisykk2007-06-19 13:55:37

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:) 可是因为里面有数字也有text,也可以定义为text吗 -daisykk- 给 daisykk 发送悄悄话 daisykk 的博客首页 (0 bytes) () 06/19/2007 postreply 14:28:40

"144566" 也是text 不是吗 -南洋暴雪- 给 南洋暴雪 发送悄悄话 (0 bytes) () 06/19/2007 postreply 14:30:37

>.<还是不行啊,还是要一个一个改阿~~~>.<~~~ (图) -daisykk- 给 daisykk 发送悄悄话 daisykk 的博客首页 (378 bytes) () 06/19/2007 postreply 14:33:19

sigh... -南洋暴雪- 给 南洋暴雪 发送悄悄话 (130 bytes) () 06/19/2007 postreply 14:34:46

可是在text2col.看不到那个'号. -daisykk- 给 daisykk 发送悄悄话 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- 给 daisykk 发送悄悄话 daisykk 的博客首页 (0 bytes) () 06/19/2007 postreply 14:56:22

请您先登陆,再发跟帖!