Instant Fraction Formatting
Instant Fraction Formatting
10
jproj (Chemical)
(OP)
For thoss of you who (like me) hate entering a fraction and having it displayed as a decimal (or a date for that matter, if you forget the =3/8 )... I came across the following in my VBA book:
You can enter the following directly into a cell and have Excel automaticlly recognize it as a fraction.
Example: To get the fraction "3/8" to enter to a cell, type the following (minus the quotes):
"0 3/8" (zero followed by a space and the fraction)
Likewise...
typing "1 10/8" returns the (mixed) fraction "2 1/4"
Hope this proves useful to someone!
jproj
You can enter the following directly into a cell and have Excel automaticlly recognize it as a fraction.
Example: To get the fraction "3/8" to enter to a cell, type the following (minus the quotes):
"0 3/8" (zero followed by a space and the fraction)
Likewise...
typing "1 10/8" returns the (mixed) fraction "2 1/4"
Hope this proves useful to someone!
jproj





RE: Instant Fraction Formatting
Now I know all you people knew this, but I've been working with Excel and Lotus (as well as Visacalc)for a long time and never knew this.
RE: Instant Fraction Formatting
Thanks jproj.
RE: Instant Fraction Formatting
Very useful!
RE: Instant Fraction Formatting
What excel is missing is a rounding error indicator. My HP calculator will display fractions with an indication of whether the displayed value is higher or lower than the actual value.
-JimB