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. Follow the instructions below for how to correct this.
How to 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.
How to Change the Number Formatting on Office 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.