请问个excel的问题 daisykk2007-06-19 21:55:37

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

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

原来是这样哦

ohh.. thanks:) 可是因为里面有数字也有ｔｅｘｔ，也可以定义为ｔｅｘｔ吗

＂１４４５６６＂　也是text 不是吗

>..

sigh...

use Replace function to replace ' , and the use the format funct

我试过了，一定可以的

这个我也试了，replace doesn't work for ' somehow

forget to tell you, highlight the whole column......

可是在text2col.看不到那个＇号．

got it~ thank you so much!

=right(A1,10)

or copy to Word, and use Replace in Word.

回复：请问个excel的问题

用right或者left，看一下help