What custom format are you using?

Another possibility would be to use =CONCATENATE([your formula]," to 1")

Dave

--
Brevity is the soul of wit.


"djerome" wrote:

I am trying to do some ratio analysis on some of our trusts. The way I want
the ratios to appear in the screen is "X to 1" X being integer result of my
formula. I have been able to go into custom format and get .29 to 1 where I
want it to show 29 to 1.

Any help would be greatly appreciated.