This is prefect! Thank you!

"Stefi" wrote:

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