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!
Bookmarks