Thread: Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?
You could also use a text formula to get the actual date...

=VALUE(CONCATENATE(MID(A2,4,2),"/",LEFT(A2,2),"/",RIGHT(A2,2)))

and manipulate in vba to get what you want.


Reply With QuoteReply With Quote