Can't give format to a column of dates

aniascua 

I have a dataset, really big, over 44.000 rows and 5 columns.

And i wanna change the format of the date column, which should be dd/mm//yyyy

and it looks like this: 

910222

when it should look like this:

9/10/2022

Are you sure that the unchanged date isn't 9102022? Was that a typo? That's a bit of a side issue, but could be significant.

I'm going to assume that you're getting these 44,000+ rows from another source, that you haven't entered them yourself. So a first pass might be to see if you can get that source to give them to you in the desired format. 

If that's not possible, then it becomes a matter of whether that "incorrectly formatted" date is a text or a number. And it's hard to tell from the single example you give. Could you supply some more examples, copying directly from the database. Include days and months consisting of single digits as well as those with two,

I'd be curious how March 9th 2022 appears, for example, whether it's 09032022 or 93222 (or something else). If the former, that would pretty much assure us that we're dealing with a text field, and that some of the text manipulation functions could easily turn it into a true Excel date. But let's take the first step: give us some more examples.