software

I'm trying to display the ratio between two cells so that it looks like 2:1.

How do I go about this?

Alice

Hi Alice

In a post yesterday, JE McGimpsey answered the following

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

with

gt;One way:

gt;Format/Cells/Number/Custom 0.00\:1

I hope this helps

--
Regards

Roger Govierquot;alicequot; gt; wrote in message
...
gt; I'm trying to display the ratio between two cells so that it looks
gt; like 2:1.
gt;
gt; How do I go about this?
gt;
gt; Alice

assume 1.20 is in cell A1

in cell A2 enter concatenate(A1,quot;:1quot;)

if you only want to use cell A1 format the cell selecting custom,
choose 0.00 and then type in quot;:1quot; after the last zero

robert111--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=517264