Get Dates with only the leading and trailing commas for each cell|VBA & Macros|Excel Forum|My Online Training Hub

Hello everyone my name is Maurizio
And my problem is this:

On an Excel sheet from the Column ("A2: A32") I manually enter the dates of the month which I then want to export to a Txt File

While in Column ("C2: C32") I created a Routine that copies the dates of Column (A) to column (C) if necessary

Now the things he wants to get are these:
1) because when I save the file (TXT) in my Subfolder, it is not classified as a Text File; But simply File.
2) the dates I was able to get once saved in the file; have this feature ("01/01/2022")

While I Wish They Were Reported In This Precise Way:
, 01/01 / 2022,02 / 01/2022 ,, As Final Date.
According to you it is possible to achieve all this
Thanks for all the help you want to give me on this
Greetings from A.Maurizio

<img alt="1° Image" src="[Image Can Not Be Found]" /> <img alt="2° Image" src="[Image Can Not Be Found]" />

<img alt="3° Image" src="[Image Can Not Be Found]" />