software

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(quot;F2quot;).Select
ActiveCell.FormulaR1C1 = quot;=TODAY()quot;

Thanks,
Aaron

format cell ==gt; CUSTOM ==gt; YYYYMMDD

quot;Aaronquot; wrote:

gt; Hello all,
gt;
gt; I have the following code but I want the date format to be YYYYMMDD with no
gt; dashes or backslashes. Could you please help.
gt;
gt; Range(quot;F2quot;).Select
gt; ActiveCell.FormulaR1C1 = quot;=TODAY()quot;
gt;
gt; Thanks,
gt; Aaron

Insert this line:
ActiveCell.NumberFormat=quot;yyyymmddquot;

Regards,
Stefi
?aron??ezt ?rta:

gt; Hello all,
gt;
gt; I have the following code but I want the date format to be YYYYMMDD with no
gt; dashes or backslashes. Could you please help.
gt;
gt; Range(quot;F2quot;).Select
gt; ActiveCell.FormulaR1C1 = quot;=TODAY()quot;
gt;
gt; Thanks,
gt; Aaron

This is prefect! Thank you!

quot;Stefiquot; wrote:

gt; Insert this line:
gt; ActiveCell.NumberFormat=quot;yyyymmddquot;
gt;
gt; Regards,
gt; Stefi
gt;
gt;
gt;
gt; ?aron??ezt ?rta:
gt;
gt; gt; Hello all,
gt; gt;
gt; gt; I have the following code but I want the date format to be YYYYMMDD with no
gt; gt; dashes or backslashes. Could you please help.
gt; gt;
gt; gt; Range(quot;F2quot;).Select
gt; gt; ActiveCell.FormulaR1C1 = quot;=TODAY()quot;
gt; gt;
gt; gt; Thanks,
gt; gt; Aaron