How to make it stops? Tried many different formattings and it gives no difference. Could not find anything in settings. Googling only gives how to stop google sheets from auto-formatting numbers into dates, which is not the problem.

CodePudding user response：

also you could use:

="01/01/0001"

to calculate the age vertically try:

=SUMPRODUCT(REGEXEXTRACT(B1:B2, "\d{4}")*{-1; 1})

or horizontally:

=SUMPRODUCT(REGEXEXTRACT(A11:B11, "\d{4}")*{-1, 1})

CodePudding user response：

Make sure to edit the number after setting the format as text. Below is an example of what I mean: