cell format keeps reverting to automatic (text)
In numbers I have cells with text in the format of 14.08.24 . These are actually dates in Euro format. I created a date format dd.mm.yy. I try to set the format of this column to the new date format but it always reverts to automatic and does not recognize the string as a date.
MacBook Air 13″, macOS 15.0