DOLLAR in WPS Spreadsheet: Create Currency Text Without Losing Your Numeric Source

The official WPS DOLLAR lesson documents this function for WPS Office for Windows Personal. The source was checked on October 19, 2026. It does not establish the first release, the last supported release, or an exact installed build. Availability in Mac, Linux, web, mobile and other editions remains unverified.

Examples below distinguish documented behavior from independently calculated controls. No results were captured from a new WPS execution for this guide. No native screenshot or cross-client compatibility test is claimed.

=DOLLAR(number,[decimals])

The WPS syntax line prints DOLLAR(number,decimals) without optional brackets, but its argument description explicitly says that omitting decimals uses 2. Brackets above express that documented optionality; do not type brackets into a formula.

With decimals equal to 0, the represented amount is a whole number. With -1 it is rounded to tens; with -2 to hundreds. The source describes rounding but does not establish every halfway or fractional-decimals boundary. The examples avoid those unresolved cases.

WPS explicitly says both the function’s name and its currency symbol depend on language settings. Therefore a dollar-sign string is not a universal expected result. The help text illustrates a dollar-style pattern; that pattern alone does not establish what every Chinese, Thai or other-language installation will display.

This guide verifies the rounded amount independently and identifies the result type as text. Exact grouping characters, currency symbol, negative-number presentation and spaces should be recorded from the intended installation before using these strings in an export. A symbol is a display choice, not evidence that an amount has been converted into a different currency.

Enter 1234.567 in B1. Use these formulas in separate cells:

The amounts are control values, not literal locale-independent WPS strings. In a dollar-symbol, comma-grouping, decimal-point configuration, the first result would be expected to look like $1,234.57; that conditional display has not been native-tested here.

Omitted decimals and an explicit 2 should represent the same amount. Negative decimals do not mean a negative result: they specify the rounding position. Keep enough precision in the original cell to avoid rounding the source before the final display step.

Build this small invoice illustration:

In D2 enter =B2*C2, then fill down to D3. The independent numeric results are 59.85 and 16.80. In E2 enter:

=DOLLAR(D2,2)

Fill down for display labels. E2:E3 are currency text representing those amounts; D2:D3 retain the numeric calculations. A total formula =D2+D3 is independently expected to be 76.65. Apply DOLLAR only to the final total label if that output must be text.

This layout avoids making arithmetic depend on whether a particular function or import path will coerce a localized currency string back into a number. WPS’s lesson discusses automatic conversion in calculations, but it does not justify assuming that every operator, aggregation function, export tool or locale will treat the strings identically.

On a separate sheet, consider three lines whose unrounded numeric amount is 0.334 each. In B2:B4 on that new sheet, enter 0.334. The arithmetic sum is 1.002. A final display formula:

=DOLLAR(B2+B3+B4,2)

represents 1.00 after rounding the combined amount. In contrast, each separate =DOLLAR(B2,2) label represents 0.33; the three displayed line amounts visually add to 0.99.

This one-cent difference is an arithmetic consequence of when rounding occurs, not an error fixed by changing the currency symbol. If the chosen reporting rule rounds each line first, use numeric ROUND helper values before totaling them. If it rounds only the final total, preserve the original line values. The applicable accounting or invoice rule must be chosen explicitly; DOLLAR does not select it for you.

Back on the original invoice sheet, for a narrative report, ="Total: "&DOLLAR(D2+D3,2) creates a text label representing 76.65 in the invoice example. Its exact currency characters remain locale-dependent. Keep the numeric total available elsewhere for sorting, charts and downstream calculations.

• Need a numeric currency value? Use cell number formatting. The official lesson distinguishes this from DOLLAR: formatting leaves a number numeric, while DOLLAR produces text.
• Unexpected symbol or function name? Check the installation’s language settings and the local function interface. The documentation explicitly makes these language-dependent.
• Unexpected tens or hundreds? Inspect a negative decimals argument; -2 rounds to hundreds, not two places after the decimal point.
• Unexpected total? Check whether the source values were rounded individually or only after summing, and whether totals reference numeric inputs rather than display strings.
• Formula error? Start with a direct numeric literal and integer decimals. The cited WPS page does not enumerate precise error codes for all invalid inputs, so no unsupported error mapping is asserted here.

DOLLAR is a text-producing display function. TEXT provides a separate approach when a chosen format code is needed, while numeric ROUND is useful when the rounded value must remain part of arithmetic. None of these functions supplies an exchange rate.

• Official WPS DOLLAR lesson (Chinese; Windows Personal documentation).

The documentation establishes the syntax and stated behavior. Original examples were checked independently under the assumptions stated alongside them; target-build execution remains a separate check. Version boundaries have not been inferred from another spreadsheet product.