How do I express a ratio?

Jen · Feb 27, 2006

Hi! I am trying to figure out how to express a ratio in excel. I need to
express the following: 1.20:1 instead of just 1.20. Can I do that somehow?

JE McGimpsey · Feb 27, 2006

One way:

Format/Cells/Number/Custom 0.00\:1

Jen · Feb 28, 2006

Thank you! That worked!!

JE McGimpsey said:
One way:

Format/Cells/Number/Custom 0.00\:1