Removing decimals after date and time

Hi all

I got a datasheet, where I have the date under ''SyrningStart'' with "dd-mm-yy hh-mm-ss", BUT in the datasheet they have a . after the seconds so I can't handle it as date our anything.

I is set as date, but is not behaving like date. The first row, I deleted the numbers after . and then it changes to the date.

How can I remove the . without deleting manually for 10.000 rows?

I have attached the attached a picture and the file
Sk?rmbillede 2023-04-14 205140.png

Hope you can help :-D Time not working.xlsx

change formatting to YYYY-MM-DD HH:MMM:SS without .0 at the end
but check if your dates are real dates not text
eg. =ISTEXT(G3)

I executed a simple text to columns on the entire column, and converted the date/time stored as text to date/time serial numbers, while retaining the fractional second information:

1) Select data A4:A10409
2) Date -> Text to columns
2a) Delimited or Fixed width, doesn't matter which, since there is only one column in the result.
2b) At step three of the text to columns wizard, select the "Date" radio button and specify YMD dates. I also specified to have the result output to D4 so that I could compare the parsed data to the original.
3) My copy of Excel defaulted to a mm:ss.0 number format, so I then formatted the column (column D, since I did not overwrite the original) as "yyyy-mm-dd hh:mm:ss.000"
4) Test and evaluate the result. My spot checks indicated an accurate conversion from text to number.

Using text to columns as a strategy for converting numbers stored as text to numbers is described here: https://support.microsoft.com/en-us/...rs=en-us&ad=us

Does that work for you?