Formatting cell

[LeeHitchen]

Hi

I have 2 value in cells b1 & c1. I want to divide c1 by b1 but dispaly the result as a ratio with b1 as base 1 ie 1:0.04 (2 decimal places only. Can anybody please help?

Regards

Lee

 

[paelinck]

Could this be what you want?

Put the formula =c1/b1 in the desired cell and format this cell with the following "custom" format:

"1:"0.00

Marc

 

[LeeHitchen]

I was messing around with custom but couldn't get it to work! Thanks for your help Marc

Lee

 

[Mark W.]

On 2002-03-21 06:01, LeeHitchen wrote:
Hi

I have 2 value in cells b1 & c1. I want to divide c1 by b1 but dispaly the result as a ratio with b1 as base 1 ie 1:0.04 (2 decimal places only. Can anybody please help?

Regards

Lee

="1:"&ROUND(C1/B1,2)