How to Use WPS Number Field on macOS

Use WPS Number Field with 4 how-to topics, all available without membership; choose a topic from the index and follow the steps to complete the setup.

How-to Index

How-to Guide

1. Create a Number Field

Entry point: Click the + button on the right side of the header → open the Field Type list → select Number

1. Click the + button on the right side of the table header.
2. In the field type list, select Number.
3. Enter the field name.
4. Click OK to finish creating the field.

Success Criteria

• Interface result: A new number field column appears in the data table.
• What you can do next: You can enter values in the field or open field settings.

Tips While Using

• Common mistake: If you do not choose the Number field type, the new field may not include number-format settings.

2. Set the Number Format

Entry point: Right-click the field header → Field Settings → Format

1. Right-click the number field header.
2. Select Field Settings.
3. Find the Number Format option in the settings panel.
4. Choose the format you need, such as integer or 1 to 9 decimal places.
5. Click OK to save the setting.

Success Criteria

• Interface result: Values in the field are displayed in the selected format.
• What you can do next: You can continue entering or reviewing values in the field.

Tips While Using

• Common mistake: Changing the display format does not change the stored numeric value.
• Environment note: The number-format option appears only for number fields.

3. Set a Default Value

Entry point: Right-click the field header → Field Settings → Default Value

1. Right-click the number field header.
2. Select Field Settings.
3. Find the Default Value option in the settings panel.
4. Enter the preset numeric value.
5. Save the setting and check the auto-filled result when you add a new record.

Success Criteria

• Interface result: New records show the preset value automatically in this field.
• What you can do next: You can still edit the auto-filled value for individual records.

Tips While Using

• Common mistake: A default value usually applies to new records only and does not batch-update existing records.

4. Show the Thousands Separator

Entry point: Right-click the field header → Field Settings → Show Thousands Separator

1. Right-click the number field header.
2. Select Field Settings.
3. Find the Show Thousands Separator option in the settings panel.
4. Turn on Show Thousands Separator.
5. Save the setting and review the display result.

Success Criteria

• Interface result: Large numbers are displayed with thousands separators.
• What you can do next: You can continue editing values without affecting calculation use.

Tips While Using

• Common mistake: The thousands separator changes display only and does not change the value itself.