FIXED function

Function Type: Text

Description:

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

The result will be a text (alphanumeric) type.

Function Structure:

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

Argument Breakdown:

number – The number to round and format.

decimals – Number of decimals to use. Default is 2.

no_commas – Suppress commas. TRUE = no commas, FALSE = commas.

Example:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->