When entering data into a cell in a workbook, you may notice that it automatically changes to something different from what you entered. Ex: a numerical value is entered, but it changes to a date when you move to a new cell. To correct this, please follow these instructions:
Change the Number Formatting on the Desktop App
1. Click on a cell or highlight multiple cells you want to change.
2. Click on the Home tab in the top navigation bar and click the drop-down menu in the Number section.
3. Select the preferred number format.
Change the Number Formatting on Microsoft 365 Online
1. Click on a cell or highlight multiple cells you want to change.
2. Click on the Home tab in the top navigation bar and click the drop-down menu in the Number section.
3. Select the preferred number format.
Number Formats Glossary