Worksheet.change vs. worksheet.calculate event

[dss28]

I want to add code to some columns in a sheet to define the number format or date format using the following codes

ThisWorkbook.Sheets("Report").Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "mm-dd-yyyy"     ' date format 

ThisWorkbook.Sheets("Report").Range("J2:J" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "0.00"             ' two digit number format

should I be using the worksheet.change event or worksheet.calculate event? or just worksheet.activate event?
please guide

 

[Peter_SSs]

Why not just apply the particular format to the whole of each column? Then it should never need adjusting by any sort of event code.

 

[dss28]

Why not just apply the particular format to the whole of each column? Then it should never need adjusting by any sort of event code.

Thanks Peter
yes I want to apply to the whole column, does the code requires any modification?
where should I place the code - in sheet as Private Sub Worksheet_Activate() code or separate new module

 

[Peter_SSs]

Why code at all? Why not just manually apply the format to each column E & J?

If you especially want to do it by code

ThisWorkbook.Sheets("Report").Columns("E").NumberFormat = "mm-dd-yyyy"     ' date format
ThisWorkbook.Sheets("Report").Columns("J").NumberFormat = "0.00"           ' two digit number format