FIXED « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. FIXED
22.10.FIXED
22.10.1.FIXED(number,decimals,no_commas) formats a number as text with a fixed number of decimalsFIXED(number,decimals,no_commas) formats a number as text with a fixed number of decimals
22.10.2.=FIXED(A2, -1)=FIXED(A2, -1)
22.10.3.=FIXED(-1234.567, -1, TRUE)=FIXED(-1234.567, -1, TRUE)
22.10.4.=FIXED(44.332)=FIXED(44.332)