Welcome to SPN

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

Sign Up Now!

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
    >
    >
    >
     

Share This Page