View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Convert string to date

Hi! I have a macro that prints a long series of dates on a worksheet. However
I cannot use these dates as proper dates in excel. Excel simply does not
understand that they are dates. Please help me solve this! Here is the code
when I print the dates (it is really in a loop but I left that code out).

Application.ThisWorkbook.Sheets("Settings").Cells( 6 + iq, 4) = strDate