I have dates conditionally formatted to read as **Year Month** after 1700, **AD Year** from 0-1700, and **Year BC** before 1 AD (eg: 2021 Aug, AD 500, 500 BC; interestingly, there is no Year 0 in the Gregorian/Julian calendars, with 1 BC hopping right to AD 1 on New Year’s Day). It’s done using this formula:

`[>-73046]JJJJ MMM;[<-693595]EE" BC";"AD "EE`

Those numbers are the values for the days December 31, 1699 and January 1, 1 AD, respectively. EE is code for “era”: Number Format Codes - LibreOffice Help. Upon restarting that formula always changes to:

`[>-73046]JJJJ MMM;[<-693593]YYYY" BC";"AD "YYYY`

… not affecting recent, post-1700 dates but rendering the AD/BC ones with leading zeros and negative signs, so as AD 0500 and -0500 BC from the example above. Changing the formula back and restarting Calc results in the same problem.

Changing the Date Acceptance Patterns as recommended on Why does LO change a date format? - #4 by Lupp didn’t fix things.

Help? I feel there must be some change-on-save setting I must be missing, some simple checkbox I need to check or uncheck somewhere…