Hi Folks

The following code copies range A to M from old workbook to new workbook. Date format of M column in the old workbook is "yyyymmdd" but somehow after I ran the macro, the date format in the new workbook changes to yyyy/mm/dd. I cannot format the new book as it is lock by the author. Any idea how to keep the date format in yyyymmdd on my end? Need help please!



Workbooks("New.xls".).Worksheets("A").Range("A" & n ":" & "M" & n).value = Workbooks("Old.xls").Worksheets("A").range("A" & i ":" & "M" & i).value