View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How can I write a fromula to subtract 1/4 from 1/2 and so on?

I like to use 0 1/4, sing a spaces seems to leave text in XL2003
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
There is a trick to entering and using fractions. To enter 1/4 use:

= 1/4

Note the single space after the equal sign. This means you won't have to
waste time converting all you fractions to decimals.


You should also checkout the CONVERT() worksheet function. It makes it
easy
to convert tablespoons, teaspoons, cups, pints, quarts,etc.
--
Gary''s Student


"Excell novice" wrote:

I am trying to find a way to (increase or Decrease) a recipe formula.

Please Help.

Thanks