| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format question
format cell == CUSTOM == YYYYMMDD
"Aaron" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format question
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell date format doesnt change | Excel Worksheet Functions | |||
| Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| DATE Format | Excel Worksheet Functions | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
Linear Mode
