Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    London, Gtr London, England
    Thanked 0 Times in 0 Posts

    Formatting to present a ratio (XP SP2)

    Dear Loungers,

    Another presentation question. I want to present ratios e.g. number of staff: number of jobs would be 1:250, how can I do this - other than by a formula with concatenated, calculated values?

    thank you.................. liz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 30 Times in 30 Posts

    Re: Formatting to present a ratio (XP SP2)

    You can format a number as a fraction, and you can specify how many digits you want to allow for the numerator and denominator, or you can specify that you want to display the fraction as halves, quarters etc. You can select these formats in the Fraction section of the Number tab of Format | Cells...
    If you specify at most 3 digits, the number 0.004 would be displayed as 1/250. There is no support for 1:250 as a format, as far as I know.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts