Okay ...
I type 12/04/2024 in D4
>>> A7 is 12/04/2024
I type 3 in D5
>>> A7 is 12/04/2024 Noted:
# cell D5 is totally separate cell with any formulas.
# cell D3 - for some reason someone would like to use "0" (text) instead of 0 (zero)
... if You would like to use text there ... then format that cell as text
What kind of challenge do You have?