|
|
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.
|
||||
Welcome to Easy Web Tips! We’re here to simplify navigating the digital world with beginner-friendly tutorials on essential tools and online platforms. From setting up Google accounts to mastering Gmail, organizing files in Google Drive, and even learning quick video editing tips, our step-by-step guides help you become more productive and secure online.
Showing posts with label Fixed Formula. Show all posts
Showing posts with label Fixed Formula. Show all posts
Sunday, September 25, 2011
Fixed Formula
Subscribe to:
Posts (Atom)