FIXED Function (Functions in Excel)
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. |
0 comments:
Post a Comment