FIXED Formula in Excel
Tuesday, Jul 07
commerce curve online accounting course

How to Use the FIXED Formula in Excel

The FIXED formula is used when you want to modify the value of a cell to remove the decimals or commas.

Formula explanation:

  • Number: The value or cell which you want to fix.
  • Decimals: The number of decimals you want to fix.
  • No commas: Refers to whether you want commas in the value or not (i.e. nothing or FALSE = with a comma, and TRUE = no comma).


In the following example, we are going to fix the values in the value column based on the details of the “Required Fix” column.

I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!



Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

5 + 9 =