Excel Won't Format my Date

This is odd. Supposing that the actual cell contains a value - ie it is possible to add 1 to it and get a good result - the rest is just formatting. Mind, I get nervous when you write "I need the date in this format". The format should have no impact on downstream calculations. So perhaps your values ("01/01/2022 00") aren't numbers at all, but strings? Ouch - that means your data import has failed. That is more serious. But it is also curious because it does not sound like the original export was a string. (A string export would not be reformatted.) I do not understand what is going on. And if you are exporting numeric values, what difference can their formatting make on your downstream processing?