View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_103_] mudraker[_103_] is offline
external usenet poster
 
Posts: 1
Default Date time conversion

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

--
Message posted from http://www.ExcelForum.com