Hi guys,

i am facing a situation where i have multiple format of dates in a column. An example will be row 1-5 will be 15/1/11 and row 6-10 will be 1/15/11. however i am very sure that all these dates are supposed to be January.

I would like to know if there are anyway to use VBA to format all these date to one standard format???


Thanks and
Regard

Ryan Yu