Hi All,
this is a strange one, when i format a cell for date= dd/mm/yy the date entered as 12/1/22 is shown as 1/12/22 in the cell, but in the formula bar is is showing correctly as 12/1/22
We use international date format not US

Any ideas as to why to is happening ???

regards
Trevor