Sent from my iPhone
> On Oct 2, 2021, at 8:48 AM, Brian Barker
> 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/YY entered by mistake.
>
> No, that makes no sense. The questioner asked
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/YY 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
It is also possible that there is a User-defined Cel Format like DD/MM/YY
entered by mistake.
> Op 2 okt. 2021 om 11:57 heeft Brian Barker
> het volgende geschreven:
>
> At 19:55 02/10/2021 +1300, Derek Ward wrote:
>> In 4.1.10 calc, using replace to change a date from 03/03/20 to
At 19:55 02/10/2021 +1300, Derek Ward wrote:
In 4.1.10 calc, using replace to change a date from 03/03/20 to
03/03/2020 actually changes it to 03/03/202020.
The only bug is probably in your understanding of how spreadsheets
work - in particular the distinction between what is displayed for a
Op 2 okt. 2021 om 09:12 heeft Derek Ward het volgende
geschreven:
>
> In 4.1.10 calc, using replace to change a date from 03/03/20 to 03/03/2020
> actually changes it to 03/03/202020.
>
It’s probably the format of your Cell.
Go to Format Cell select Date format and select a valid entry
