How do I express a ratio?

[Jen]

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]

One way:

Format/Cells/Number/Custom 0.00\:1


In article <5230FB96-5D2B-47A2-9661-8138CD35F3D8@microsoft.com>,
Jen <Jen@discussions.microsoft.com> wrote:

> 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?

[Jen]

Thank you! That worked!!

"JE McGimpsey" wrote:

> One way:
>
> Format/Cells/Number/Custom 0.00\:1
>
>
> In article <5230FB96-5D2B-47A2-9661-8138CD35F3D8@microsoft.com>,
> Jen <Jen@discussions.microsoft.com> wrote:
>
> > 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?
>