Excel 16.33 for Mac has a bug the prevents the display of cells that have been formatted as "Currency"
When selecting a cell and changing the format to "Currency," the cell vanishes. The value is still there, however is does not display to screen. When re-formatting back to "Number" the cell re-appears.
I have this problem too. It's a big problem. It's a bug. Excel should find the value, regardless of how it's formatted, e.g. currency, percent, etc.