Remove dots from date values

Hello!
Is there a way to remove the dots from excel values?

I have a column with full of dates like this "2023.12.14", and i want it to look like this 20231214 in the column next to it.

It is in date format. I've read in other forums about the use of Subsitute function which when i use like this =SUBSTITUTE(A2;".";"") it gives me 45274 back. Then i tried using =DATEVALUE function on the number i got but it gives back #VALUE! error.
When i try using the TEXT function like this : =TEXT(A2;yyyymmdd) OR like this : =TEXT(A2;yyyy-mm-dd) it gives back yyyy00dd and yyyy-00-dd as the value.

is there a way doing it without the replace menu and without having support colums?

Thank you!

Sounds like they are real dates so you can change the cell format to "yyyymmdd"

Originally Posted by Fluff13

Sounds like they are real dates so you can change the cell format to "yyyymmdd"

Ye sorrry i forgot to tell that i need only the month and day, so in this case 1214. When i do the thing you said it works yes, i get the result(20231214) but i can't work with it because when i try to cut the 1214 off the end, the result comes back in the serial number form, like i cut it off the serial number not the actual date and i get something like 3457 instead of 1214 and so the problem still persists, since again i can't convert that number to the actual month day value.

In that case you will need to use

Formula:

Please Login or Register  to view this content.

My god i was dumb, i got wrong values because i literally used it like my excel is in english even though its in my native language...Thank you! This is what i was looking for anyways!

Glad to help & thanks for the feedback.