How can we help you?
Fraction
Fraction▾
- Identify cell format
- Open number format settings window
- General
- Number
- Currency
- Accounting
- Date, Time, and Date and Time
- Percentage
- Fraction
- Scientific
- Text
Product:
Application:
The Fraction format is used to display fractional numbers as ordinary fractions, that is, the fractional part is replaced by a numerator and denominator.
A number formatted as Fraction
In the Fraction format, the numerator and denominator are calculated in two ways:
•Exact (for example, 0.5 = 1/2)
•Approximately (for example, 1.6789 = 1 2/3)
Was this helpful?
Yes
No
