change date format by vba code

Hi All,

pls help
how to change the date format for column b to column c . we have
thousands data in column b so we need vba code to do this job

pls find attached file

thanks all
best regards
tom

It needn't vba code if you just want change date format no matter how many cells you have. Right click column's head, then setting cells' format.

dear sir,

if we have many sheet , and we need to do this again and again. hope we have vba code to minimize the work
and we just right click columns head, then setting cells format, it don't work

hope we have vba code to do this job. it is only one sheet for ask help. actually we have many sheet like this
thanks for your great idea and help. many thanks

Thanks
Tom

As your wish.
Try

Dear sir

thanks for your great help. i am very fresh for vba code. we try but dont work
that is file name"change date format questions" after vba code the file will become"change date solutions"

thanks for your help
tom

If dates have always 10 characters this wil do



Kind regards
Leo

dear all,

both solution is work. it is great . many thanks. but the final solution is to change the date to number format as file attached. after vba code, we cannot change to number format. pls help

many many thanks
tom

Did you test the file @ post #6


Kind regards
Leo

yes , the problems solved