Fixed Formula
|
|
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.
|
||||