Can Excel format numbers up to 2 digits and handle integers correctly?

Question

excel

We need a format for Excel so that ...
12 → "12"
12.3 → "12.3"
12.34 → "12.34"
12.345 → "12.35"
Direct "0.##" is not good: formats 12 as "12," with an extra decimal point.
And LOo formats correctly!
Or am I asking for the impossible and is this a standard Yoksel glitch?

Answer 1

Something you are not picking there.
Cell format - numeric - put the required number for mathematical rounding.
Or the "main" panel - there you select the "numeric" format and press the button with 00, choosing the location of the separator

Answer 2

Although the answer has already been given, I will offer my own version.
I give an example for numbers taken from column A. The result is in column B.
Column C was made as a check that it is possible to perform mathematical operations with the result in the future.
So for B2 we have the formula = IF (MOD (ROUND (A2; 2); 1) = 0; TEXT (A2; "0"); TEXT (A2; "0.00"))
I think if you can adapt it to yourself
Solution example: