How to use the Number Format Generator.
Number formats change display, not the underlying value. Confirm how zero, negative values and decimals should appear.
Make the workflow fit your task.
Describe how positive, negative, zero and text values should display, including precision and units. Distinguish formatting from rounding stored values. Test representative numbers in the target application's locale, checking whether the display conceals meaningful precision.
- What you provide
- Desired display and spreadsheet application.
- What you get
- Custom number-format code with example outputs.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Display numeric values with two decimal places in a compatible spreadsheet.
Completed example
Use a suitable two-decimal format such as 0.00; verify locale-specific decimal display and that the stored value remains unchanged.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Does showing two decimal places round the stored number?
A display format normally changes presentation only. Use an explicit rounding calculation when the underlying result must change.
Why does a percentage format show 2500% instead of 25%?
The stored value may be 25 rather than 0.25. Confirm the data convention before changing the format or scaling values.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑