Hi, I would like to recreate this formula (see below) to a whole column but I
am incapable to do so. The problem come from the date format which I cannot
change with usual format. They only way I found out was to select the cell,
then copy the formula and paste it using the text importation wizard (that I
can see when I paste the date). Any other way to go throught this would be
accepted.

Thanks!

Range("M4").Select
ActiveCell.FormulaR1C1 = "09/27/2006"
Range("W4").Select
ActiveSheet.PasteSpecial Format:="Texte Unicode", Link:=False, _
DisplayAsIcon:=False
--
Mathieu