Date time conversion

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi, I need to convert the following date into a specific format for export
to a text file.

Worksheet date: 11/14/2002 1:30:00 PM

Need to convert to 021114.1330 (ie YYMMDD.HHMM, where the HHMM is in 24
hour time)

Thank you.
 
Do you require a cell format or macro data entered into a cell via
macro?

for macro



activecell.value = format(now(),"yymmdd.hhmm")
In using the above code i have come across a problem where the dat
does not appear in the correct format. To overcome this problem i use

sDate$ = format(now(),"yymmdd.hhmm")
activecell.value = sdat
 
Back
Top