How to Use WPS Number Field on Windows

Use WPS Number Field with 4 how-to topics, including 4 free topics and 0 membership-related items; start from the index to create a field, set formats, set a default value, and show a thousands separator.

How-to Index

How-to Guide

1. Create a Number Field

Entry path: Click the + button on the right side of the header → open the Field Type drop-down list → select Number

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

Success Criteria

• Interface result: The new number field name appears in the header.
• What you can do next: You can enter numeric values in the field or open field settings.

Tips While Using

• Common mistake: If the field name is left blank, add a clear name before confirming.
• Environment note: You need permission to edit fields in the current data table.

2. Set the Number Format

Entry path: Right-click the field title → Field Settings → Number Format

1. Right-click the number field title.
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.

Success Criteria

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

Tips While Using

• Common mistake: After the display format changes, it may look like the original value changed too.
• Environment note: Formatting changes display only and does not affect stored values or calculations.

3. Set a Default Value

Entry path: Right-click the field title → Field Settings → Default Value

1. Right-click the number field title.
2. Select Field Settings.
3. Find the Default Value option in the settings panel.
4. Enter the preset numeric value.
5. Save the setting so new records are filled automatically.

Success Criteria

• Interface result: New records automatically use the preset value in this number field.
• What you can do next: You can still edit the actual value in each record manually.

Tips While Using

• Common mistake: A default value applies to new records and does not overwrite existing records automatically.
• Environment note: It is helpful to set a consistent initial value based on your business rules.

4. Show a Thousands Separator

Entry path: Right-click the field title → Field Settings → Show Thousands Separator

1. Right-click the number field title.
2. Select Field Settings.
3. Find the Show Thousands Separator option in the settings panel.
4. Select Show Thousands Separator.
5. Save the setting and review how large numbers are displayed.

Success Criteria

• Interface result: Large numbers are displayed with thousands separators.
• What you can do next: You can turn the option off later or adjust other number display settings.

Tips While Using

• Common mistake: The thousands separator changes display only and does not change the numeric value itself.
• Environment note: This is useful for amount and quantity fields with many digits.