.

FIXED Function Dictionary

Function Dictionary Function Examples Function Categories

FIXED            
 
 
Original Number Converted To Text
10 10.00  =FIXED(C4)
10 10  =FIXED(C5,0)
10 10.0  =FIXED(C6,1)
10 10.00  =FIXED(C7,2)
10.25 10.25  =FIXED(C8)
10.25 10  =FIXED(C9,0)
10.25 10.3  =FIXED(C10,1)
10.25 10.25  =FIXED(C11,2)
1000 1,000.00  =FIXED(C12)
1000.23 1,000  =FIXED(C13,0)
1000.23 1000  =FIXED(C14,0,TRUE)
What Does It Do ?              
This function converts a numeric value to text.
During the conversion the value can be rounded to a specific number of decimal places,
and commas can be inserted at the 1,000's.
Syntax                
=FIXED(NumberToConvert,DecimalPlaces,Commas)
If DecimalPlaces places is not specified the function will assume 2.
The Commas option can be TRUE for commas or FALSE for no commas.
If the Commas is not specified the function will assume TRUE.
Formatting              
No special formatting is needed.
Note that any further formatting with the Format, Cells, Number command will not have any effect.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download