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

[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?!?!?!?!

 

[Joseph Meehan]

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.

 

[Guest]

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