FormulaCraft

FIXED

FIXED converts a number to a formatted text string with a defined number of decimal places and optional thousands-separator commas. Unlike TEXT, it is purpose-built for numeric formatting when you need precise decimal control and readable number strings in concatenations or labels.

Excel
=FIXED(A2,2,FALSE)
Google Sheets
=FIXED(A2,2,FALSE)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Place your numbers in column A (e.g., 12345.678 in A2).
  2. 2Enter =FIXED(A2,2,FALSE) to return '12,345.68' — rounded to 2 decimals with comma separators.
  3. 3Set the third argument to TRUE to suppress commas: =FIXED(A2,2,TRUE) returns '12345.68'.

Need a version for your data?

Try: “Display large numbers with exactly 2 decimal places and comma separators as text”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: