Wauvel

Excel like a finance pro.

← The library

Text function

FIXED

Formats a number as text with a fixed number of decimals.

Rarely usedDifficulty 1050 · CapableUsage rank #243 of 520
Practice · 2 questions →

When to use it

Rounds a number to a number of decimals and returns it as text, with or without thousands separators.

The shape of it

Syntax
=FIXED(number, [decimals], [no_commas])

Worked examples

  • One decimal

    =FIXED(1234.567,1) → 1,234.6

    One decimal with a separator.

  • Without separators

    =FIXED(1234.567,1,TRUE) → 1234.6

    no_commas TRUE drops the separator.

  • Round to hundreds

    =FIXED(1234.567,-2) → 1,200

    Negative decimals round to hundreds.

Worth knowing

  • TEXT with "#,##0.0" is the more flexible equivalent.
  • The result is text, so use ROUND if you need a number.
  • Default is two decimals.

Where it goes wrong

  • Text results do not sum.
  • Separator characters follow the system locale.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.