Formatting Issues

WPS Spreadsheet: Display an Excel Number with a Custom Decimal Position

Muhammad Talha Nov 12, 2026 869 views

Question details

The user needs to display a number such as 15123456 with the decimal point moved to produce 15123.456.

Product: WPS Spreadsheet
Device & OS: not provided
Scenario: A spreadsheet value must be displayed with a decimal position that does not follow standard number-format grouping rules.
Observed behavior: Standard custom number formats cannot insert a decimal point at an arbitrary position while keeping the original number unchanged.

Before you start

Identify the source cell containing the original number, such as A1, and decide whether the result may be text or must remain numeric. Keep the original value in a separate cell if it is needed for calculations.

Solution 1Recommended

Use TEXT with division to display the custom decimal position

Use this method when the required result is for display and can be returned as text.

Dividing the source value by 1,000 moves the decimal point three places to the left. The TEXT function then forces three digits after the decimal point. The result is text, so use the original numeric cell for calculations.

Select the display cell

In WPS Spreadsheet, click the empty cell where you want the formatted result to appear.

Enter the display formula

Type =TEXT(A1/1000,"0.000") in the formula bar or directly in the cell, replacing A1 with the source cell, and press Enter.

Check the displayed value

For a source value of 15123456, confirm that the display cell shows 15123.456. Keep A1 unchanged if you need the original number for calculations.

Expected result: The formula returns 15123.456 as text. Change the divisor or the number of zeros in the format string when your decimal position or precision is different.

Solution 2

Keep a numeric result in a separate calculation cell

Use this method when the scaled result must remain numeric for sorting, calculations, or charting.

WPS Spreadsheet solution

Format Custom Decimal Positions in WPS Spreadsheet

WPS Spreadsheet lets you create a display formula for values such as 15123456 and show them as 15123.456. Use TEXT when the result is presentation text, or calculate a separate numeric helper value when it must remain usable in formulas.

1. Open the spreadsheet: Launch WPS Office, choose Spreadsheet, and open the workbook containing the source value.
2. Add a display cell: Select an empty cell and enter =TEXT(A1/1000,"0.000"), replacing A1 with the correct source cell.
3. Create a numeric alternative if needed: For a numeric result, enter =A1/1000 in another cell and apply a three-decimal number format from the Home tab.
4. Save the workbook: Use File > Save or press Ctrl+S to save the formula and formatting in the workbook.

Display decimal positions that standard custom formats cannot place arbitrarilyKeep the original value separate for reliable calculationsUse familiar spreadsheet formulas and number-format controlsOpen and edit Microsoft Excel XLS and XLSX files with compatible formatting

microsoft office alternative - wps office

Frequently Asked Questions

Can a custom number format move the decimal point anywhere in WPS Spreadsheet?

No. Standard custom number formats support defined digit, grouping, and decimal rules, but they cannot arbitrarily relocate the decimal point while preserving the original value.

Why does =TEXT(A1/1000,"0.000") return text?

TEXT converts the calculated value into formatted text. It is suitable for display, but use the original cell or a separate numeric formula for arithmetic, sorting, and charts.

How can I keep the result numeric instead of using TEXT?

Enter =A1/1000 in a separate cell, select that cell, and set three decimal places from Home > Number Format or Format Cells. The result remains numeric.

How do I change the number of decimal places?

Edit the format string in the TEXT formula. For example, use "0.00" for two decimal places or "0.0000" for four decimal places.

Document & File Issues