Numbers
Numbers User Guide for Mac
- Welcome
-
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
- Copyright
![](https://help.apple.com/assets/6226A2B733970465D6250C17/6226A2B733970465D6250C1E/en_AU/b41caff93c0da85fc0ca4a85751cc32d.png)
Format fractions automatically in Numbers on Mac
You can set Numbers to automatically format fractions as you type them. The setting doesn’t apply to fractions you type in table cells or comments.
Choose Numbers > Preferences (from the Numbers menu at the top of your screen).
Click Auto-Correction at the top of the preferences window.
In the Formatting section, select the ‘Automatically format fractions’ tick box.
Type a fraction (for example, 1/2), then press the Space bar and keep typing, or press Return.
The setting applies to text you type from now on — it doesn’t change fractions you’ve already typed.
Thanks for your feedback.