Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

percent (decimal) problem in table- throwing off formulas in queri

Discussion in 'Information Technology' started by The Mecca, Jul 28, 2006.

  1. The Mecca

    The Mecca
    Expand Collapse
    Guest

    I have simple table with 3 columns and 1 row.

    Data Type= Number
    Field Size= double
    Format= Percent
    Decimal Places= 2

    I have typed in the following values- 1 in each column
    ..345
    ..295
    ..245

    Each of the values displays at the correct percent- 34.50%, 29.50%, 24.50%
    but when you click in each of the cells- it displays .345, 29.50%, 24.50%-
    why won't the last 2 numbers display as decimals? This is throwing off my
    formulas which are based on these tables.

    Try this yourself- enter the same criteria as above- enter the number .333
    and .332- this seems to be where they are stuck- HELP PLEASE?!?!?!?!
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    The Mecca wrote:
    > I have simple table with 3 columns and 1 row.
    >
    > Data Type= Number
    > Field Size= double
    > Format= Percent
    > Decimal Places= 2
    >
    > I have typed in the following values- 1 in each column
    > .345
    > .295
    > .245
    >
    > Each of the values displays at the correct percent- 34.50%, 29.50%,
    > 24.50% but when you click in each of the cells- it displays .345,
    > 29.50%, 24.50%- why won't the last 2 numbers display as decimals?
    > This is throwing off my formulas which are based on these tables.


    There is something different, and you need to find out what it is. I
    will suggest that it is likely in the data type or the data and not in the
    format. Formatting should have no effect on the results of a formula.
    Formatting does not change the number in any way other than how it will look
    when displayed with that format.

    >
    > Try this yourself- enter the same criteria as above- enter the number
    > .333 and .332- this seems to be where they are stuck- HELP
    > PLEASE?!?!?!?!


    --
    Joseph Meehan

    Dia duit
     
  4. The Mecca

    The Mecca
    Expand Collapse
    Guest

    Re: percent (decimal) problem in table- throwing off formulas in q

    well it would seem it is something with those numbers- I have 14 tables just
    like it with numbers above .333 or 33.30% that work just fine. It is just
    those 2 numbers

    "Joseph Meehan" wrote:

    > The Mecca wrote:
    > > I have simple table with 3 columns and 1 row.
    > >
    > > Data Type= Number
    > > Field Size= double
    > > Format= Percent
    > > Decimal Places= 2
    > >
    > > I have typed in the following values- 1 in each column
    > > .345
    > > .295
    > > .245
    > >
    > > Each of the values displays at the correct percent- 34.50%, 29.50%,
    > > 24.50% but when you click in each of the cells- it displays .345,
    > > 29.50%, 24.50%- why won't the last 2 numbers display as decimals?
    > > This is throwing off my formulas which are based on these tables.

    >
    > There is something different, and you need to find out what it is. I
    > will suggest that it is likely in the data type or the data and not in the
    > format. Formatting should have no effect on the results of a formula.
    > Formatting does not change the number in any way other than how it will look
    > when displayed with that format.
    >
    > >
    > > Try this yourself- enter the same criteria as above- enter the number
    > > .333 and .332- this seems to be where they are stuck- HELP
    > > PLEASE?!?!?!?!

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page