Excel won't follow Cell Number Formats

My Excel for Mac 16.43, part of Office for Mac 2020, recently recently started failing to recognise Number Formats instead insisting that, for instance, a value entered as '1' must be displayed, stor...