Use Of 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.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें