Caveat : When you enter the full number in the first column, be sure to use the dashes, which tell Excel to format the numbers as text. If you don’t, Excel will interpret the entry as numbers, in ...

How do I open Apple Numbers in Excel in Windows? When the Numbers file is open, go to the spanner icon in the upper right area of the screen. Click this, and a drop down menu will appear.

If the numbers keep changing to dates in Microsoft Excel, you can use the following methods to fix the issue: Format cells as text. Insert an apostrophe before the number.