Entering Fractions in Excel
Thanks Mike, This helps a lot!
"Big UT Fan" wrote:
Fractions need to be entered as such #<spacefraction. For example, "1 1/2"
(note do not use the quotations) will result in the fraction 1 1/2. To
create only the fraction, enter "0 1/2". This results in the fraction 1/2 in
the cell. Hope this helps. Mike
"Roxanne" wrote:
When entering fractions in a spreadsheet what do you add before a fraction so
that Excel does not recognize it as a date?
Somebody gave me this symbol //.
Thanks for any help!
|