Best way to convert date input to dd-mm-yy (vba)

[kelly mort]

I am accepting date input as dd-mm-yy.
A user might enter 6-7-20.

In this case, I want to convert the input to 06-07-20.
I can do this with a few case statements and or if statements.

But I am having the feeling there could be a cleaner and shorter way to do it.

Can someone point it out for me?

Thanks

 

[ChrisFoster]

Presuming your data is in column A, use this code.

Range("A2:A" & Rowcounter).NumberFormat = "dd-mm-yyyy"

 

[kelly mort]

Presuming your data is in column A, use this code.

Range("A2:A" & Rowcounter).NumberFormat = "dd-mm-yyyy"

Sorry for not being clear.

I am using an input box to accept this date.

I want to do the manipulation within memory.

Thanks