BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar

Re: How to convert character formats to date format

No, not out of turn at all... My VBA is just really weak  ... sticking to my strengths here!

0 Kudos
Highlighted
DS
DS
Contributor

Re: How to convert character formats to date format

Hi @MikeD_Anderson,

 

  I was having a similar issue as the original post did, but more with converting a date format from German style: dd.mm.yyyy to mm/dd/yyyy.

 

  I tried the InFormat() approach, but it didn't work, whereas the formula in your date example data table worked perfectly! So, I would also mark yours as a correct solution, even though it's not as elegant.

 

Thanks!,

DS