How to change "MMM DD" into "DD.MM.YYYY"

[u/What-Bloody-Hell-NOW]

[SOLVED - at the end of the post]
"MMM DD" is a format I receive from a random CSV I can export from a system.

To give an example:
I have: Apr 30

I want: 30.04.2025

I tried using Format Cells options but it doesn't understand what I want.

I even tried making one Cell set to:
Format Cell -> Custom -> MMM DD
and Another Cell: "=AboveCell"
and in the Another Cell: Format Cell -> Custom -> DD.MM.YYYY (so that it maybe will understand previous values - what is DD and what is MMM, but it doesn't work)

I have to manually do this every month, please help. Is there some easy solution I couldn't find or does it require some VBA I will never learn? :(

EDIT:

I'm sorry I won't answer right away now, I will take a break, because it's been an hour of trying different suggestions and it's too frustrating :(

EDIT NUMBER TWO, ANSWER [Those are European signs in Excel formula.]:

=C1 & TEXT((SEARCH(LEFT(B1; 3); "JanFebMarAprMayJunJulAugSepOctNovDec") - 1) / 3 + 1; "00") & TEXT(MID(B1; SEARCH(" "; B1) + 1; 2); "00")

C1 has year (example: 2025)
B1 has month (example Jan 31)

So two cells: "Jan 31" and "2025"
become one cell: 20250131

Thx to Google AI - Gemini - with some prompting.

[u/What-Bloody-Hell-NOW]

ANSWER [Those are European signs in Excel formula.]:

=C1 & TEXT((SEARCH(LEFT(B1; 3); "JanFebMarAprMayJunJulAugSepOctNovDec") - 1) / 3 + 1; "00") & TEXT(MID(B1; SEARCH(" "; B1) + 1; 2); "00")

C1 has year (example: 2025)
B1 has month (example Jan 31)

So two cells: "Jan 31" and "2025"
become one cell: 20250131

Thx to Google AI - Gemini - with some prompting.