Add zeroes within dates (NOT leading zeroes)

[anthony19]

Hello. Question regarding strings that I can't wrap my head around.

I have a list of dates in the following format: 200929 - this signifies February 9, 2009.

What I need,however, is for each such value to have eight digits - meaning I must add zeroes to the month and/or day when they're single digits. For the example above, I need it to become 20090209

Any advice on how to get started on tackling this? Any help would be appreciated.

[Pepe Le Mokko]

And what is for example 2009111 supposed to be? Jan 11th or Nov 1st ? How make the difference?

[anthony19]

Very good point.

How about if I do it before the concatenation then?

If I have a column of the months/days, is there a simple If function I can include that adds a leading zero if the number of digits<2?

[anthony19]

Have found that the REPT function does the job.

So if given 12 in A1, the formula =REPT("0",2-LEN(A1))&A1. Now having some trouble evaluating that formula in VBA - am using Evaluate but coming up with errors. Any suggestions for this particular implementation?