Formatting numbers in Excel for Mac
I have a sheet where formatting does not display correctly even though the cells in question have been formatted. This applies to both dates and numbers. For example, the date entered as 12/07/19 is displayed as 43658 and not as formatted.
On the same sheet, I have other cells formatted as numbers with 1000 separators but they are not displayed that way.
Interestingly, in both cases, the cell contents appear as text, i.e. aligned to the left, even though no alignment is chosen.
MacBook Air 13", macOS 10.14