How to change the format of a date in a cell with date and time?

Tylim  wrote:  ``trying to use the INT function to separate the date and time from a cell displaying "31.05.2022 10:00"``

Of course, in Excel, a valid date/time is indeed a number,  And INT returns the integer part, which represents the date.

I think you are saying that when you enter literally 31.05.2022 10:00 into A1, for example, Excel does not recognize that syntax as a valid date/time, so it treats it as text.  Confirm that ISTEXT(A1) returns TRUE.

Consequently, INT(A1) returns #VALUE because the value is text, not a numeric date/time.

And formatting the cell as date/time in some form does not work because formatting works only for numeric values, not text.

Presumably, INT(A1) works when you manually replace 31.05.2022 with 31/05/2022 because in your region, Excel recognizes that syntax as a numeric date/time.  Confirm that ISTEXT(A1) returns FALSE.

(In my region, I would need  to replace 31.05.2022 with 5/31/2022.)

If you enter the text 31.05.2022 10:00 into A1, you can convert it to a numeric date/time with a formula of the form =--SUBSTITUTE(A1, ".", "/") in B1, formatted appropriately.

(You might need to use semicolon instead of comma to separate parameters.)

(Alternatively, you might change you computer configuration to recognize the syntax 31.05.2022 as a valid date.  But I do not recommend it.)

The double-negate converts text to a numeric value.

If you do not format B1 appropriately, you might see the number 44712.4166666667, rounded.  That is simply the numeric value that Excel uses internally to represent date and time values.