ExcelFlux

FIXED function

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

Text

Where can you use it?

Data preparation and reporting teams. Use this group to clean, split or reformat IDs, names and descriptions before using them in reports.

Scenario in the workbook

Format a report value with a fixed number of decimals. The result is text; use ROUND when you need a numeric result.

A worked example from the workbook

RowAB
6InputSecond input
712.7892
87.5121
980
Record 1
=FIXED(A7,B7,TRUE)

Expected result12.79

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=FIXED(A7,B7,TRUE)
Turkish Excel · tr-TR
=SAYIDÜZENLE(A7;B7;DOĞRU)

Worked examples

Format a report value with a fixed number of decimals. The result is text; use ROUND when you need a numeric result.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input Second input
7 12.789 2
8 7.512 1
9 8 0
Case Formula Expected result
Record 1 =FIXED(A7,B7,TRUE) 12.79
Record 2 =FIXED(A8,B8,TRUE) 7.5
Record 3 =FIXED(A9,B9,TRUE) 8
Microsoft Excel reference