Sent from my iPhone
> On Oct 2, 2021, at 8:48 AM, Brian Barker <b.m.bar...@btinternet.com.invalid>
> wrote:
>
> At 17:12 02/10/2021 +0200, Martin Groenescheij wrote:
>> It is also possible that there is a User-defined Cell Format like
>> DD/MM/YYYYYY entered by mistake.
>
> No, that makes no sense. The questioner asked about Find & Replace converting
> 03/03/20 to 03/03/202020 - nothing about changing cell formats (which is what
> he *should* have been doing). That could happen only if the original entry
> had been as text into such a foolishly-formatted cell. Occam's razor tells us
> not to assume two such mistakes!
Exactly. I was looking at settings yesterday and there is one that controls the
automatic interpretation of YY to YYYY including which year > 29 is 19YY vs
20YY.
So here we are with someone having a Y2K issue :-)
>
> Brian Barker
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
