View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
roxanne roxanne is offline
external usenet poster
 
Posts: 16
Default 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!