Date Format question

[Aaron]

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

 

[Toppers]

format cell ==> CUSTOM ==> YYYYMMDD

 

[Stefi]

Insert this line:
ActiveCell.NumberFormat="yyyymmdd"

Regards,
Stefi



„Aaron†ezt írta:

 

[Aaron]

This is prefect! Thank you!

Insert this line:
ActiveCell.NumberFormat="yyyymmdd"

Regards,
Stefi



„Aaron†ezt írta: