ExcelBanter - How do I express a ratio?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I express a ratio? (https://www.excelbanter.com/excel-discussion-misc-queries/74209-how-do-i-express-ratio.html)

Jen

How do I express a ratio?

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

How do I express a ratio?

One way:

Format/Cells/Number/Custom 0.00\:1

In article ,
Jen 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

How do I express a ratio?

Thank you! That worked!!

"JE McGimpsey" wrote:

One way:

Format/Cells/Number/Custom 0.00\:1

In article ,
Jen 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?

All times are GMT +1. The time now is 08:32 AM.