Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > FIXED
 

FIXED(number, decimals, no_commas)

 
 Returns the text string of a number rounded to a fixed number of decimal places.

 numberThe number you want to round and convert to text.
 decimalsThe number of digits to the right of the decimal point.
 no_commasTrue or False to specify whether to include commas.

 REMARKS
 
  		• Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
     
  		• If "decimals" < 0, then "number" is rounded to the left of the decimal point.
     
  		• If "decimals" is left blank, then 2 is used.
     
  		• If "no_commas" = True, then the returned text doesn't include commas.
     
  		• If "no_commas" = False, then the returned text includes commas.
     
  		• If "no_commas" is left blank, then False is used.
     
  		• A number which has a number format applied from (Format > Cells) is still a number, whereas the result of this function is actually text.

     EXAMPLES
     
     A
    1=FIXED(1234.567,1) = 1234.6
    2=FIXED(1234.567,-1) = 1230
    3=FIXED(-1234.567,-1) = -1230
    4=FIXED(12000.75,1,FALSE) = 12000.8
    5=FIXED(44.332,2) = 44.33
    6=FIXED(44.332) = 44.33
    7=FIXED("some text") = #VALUE!
    		 
     Functions - F | Index - F | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top