Thread: How do I keep a fraction as entered (leave 12/20 not 3/5)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default How do I keep a fraction as entered (leave 12/20 not 3/5)?
Format the cell as ??/??

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mmiissttyy" wrote in message
...
I need to have fractions show up as I enter them (12/20, 13/20, 15/20).
Is
there any way to keep Excel from changing those that can be (i.e. 12/20 to
3/5)?


Reply With QuoteReply With Quote