Hmm apparently it seems that it has to do with how fast I type the value.

Ok, so let’s say that this works as intended, how do I act on what was typed in, and potentially change the value?

One thing could be to complete a date if the user types like “2” and then leaves the cell – I want to finis the value adding e.g. “02-02-2023”.
Also if the user types “0202” I want to change it to “02-02-2023” and for “02022023” -> “02-02-2023”.

Where is the correct place to catch this event and perform the action?