Date Format question
Insert this line:
ActiveCell.NumberFormat="yyyymmdd"
Regards,
Stefi
€˛Aaron€¯ ezt Ć*rta:
Hello all,
I have the following code but I want the date format to be YYYYMMDD with no
dashes or backslashes. Could you please help.
Range("F2").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Thanks,
Aaron
|