Changing the default number format
You can change the default number format for the worksheet you are currently working in. Changing the number format affects only how numbers are displayed, not how your spreadsheet stores the numbers or calculates with them.
- In the action bar, click Worksheet.
- In the pop-up menu, click Properties.
- At the top of the pop-up panel, click Number Format.
- Click a format category and a number format.
Your changes take effect immediately.
- To close the pop-up panel, click
.
See Also
Why do I need different number formats?
Formatting numbers
Formatting numbers as currency
Changing the default background and text color
Changing the default column width
Changing the default row height