View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default I need help with ratios

=A1/B1

Then:

Format Cells... Number Custom General":1"
--
Gary''s Student - gsnu200750


"Cin" wrote:

I need to take information in 2 different cells, divide it, and show the
result as a ratio 2:1.
I know how to set the formula to divide the 2 cells, but the result is a
percentage, not in the format I need to see, which is 2:1.
Help?