FIXED
Rounds a number to the specified number of decimals and returns the result as text, with optional thousands separators.
FIXED(number, [decimals], [no_commas])Arguments
numberThe number to round and format as text.decimalsNumber of decimal places (default 2). Negative rounds to the left of the decimal point.(optional)no_commasTRUE to omit thousands separators; FALSE or omitted to include them.(optional)
=FIXED(1234.567,2)Two decimals with thousands separators
=FIXED(1234.567,2,TRUE)No thousands separator
=FIXED(1234567,-3)Negative decimals round to thousands
- •Returns text, not a number
- •Useful for displaying numbers with consistent formatting in concatenated text
- •Uses the regional decimal and thousands separators
- •For richer format control, use the TEXT function instead
- •Confusing FIXED's output with a genuine number - it returns formatted text, so the result can't be used directly in further arithmetic without converting it back with VALUE
- •Forgetting that the optional no_commas argument, when set to TRUE, removes thousand separators - leaving it FALSE or omitted keeps commas in the formatted output
- •Not realizing FIXED rounds the number to the specified decimal places before formatting, so the displayed value can differ slightly from the original underlying number if that rounding matters
TEXTOffers more flexible, customizable number formatting than FIXED, including custom formats beyond a simple fixed decimal count.DOLLARFormats a number similarly to FIXED but adds a currency symbol matching the system's regional settings.ROUNDPerforms the same rounding FIXED applies internally, but returns a genuine number instead of formatted text.Can I use FIXED's result in a calculation?
Not directly - FIXED returns text, not a number. Wrap it in VALUE first if you need to use the result in further arithmetic.
How do I remove the thousand separators from FIXED's output?
Set the third argument, no_commas, to TRUE, like FIXED(1234.5,2,TRUE), which removes the commas from the formatted text.
Does FIXED round the number or just truncate it?
It rounds to the specified number of decimal places, following standard rounding rules, before converting the result to text.
Need to translate a formula using FIXED?
Use our translator to convert your complete formula