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 be a date when you move to a new cell.
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.
3. Click the drop-down menu next to the number format box (which usually defaults to 'General').
4. 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.
3. Click the drop-down menu next to the number format box (which usually defaults to 'General').
4. Select the preferred number format.