Excel - The FIXED function

April 2018


This function will return as value, a text representation of number rounded to a specific decimal places.


  • number: represents the number to be rounded
  • decimal_places: as the name suggests, the decimal places
  • no_commas: can have one of these status:
    • TRUE: commas displayed in result
    • FAlSE: commas not displayed
Published by aakai1056. Latest update on November 15, 2011 at 11:12 AM by aakai1056.
This document, titled "Excel - The FIXED function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - The TRIM function
Excel - The MROUND function