View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aaron
 
Posts: n/a
Default Date Format question

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