Thread: String as date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_16_] Steve[_16_] is offline
external usenet poster
 
Posts: 28
Default String as date

I have a 6 character string of numbers in a cell which I would like to
treat as a date, whereas I can add 1 to it in VBA and it would display
as the following day, and then assign that value to a variable. For
instance, 033109 would turn into 040109 by adding 1 to it in a
procedure. Is this possible to do in a macro?

Thanks...