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!
Brian Barker
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org