Best guess is that the cell now has General number format due to the
copy/paste. If the column width is narrow enough 3.67 will display as 3.7.

--
Jim
"Eric" wrote in message
...
|I have a worksheet I distribute to others to complete and return. I need
data
| entered to no more than one decimal place. So I have formatted the numbers
to
| one decimal place and enacted "precision as displayed." Once PAD is
enacted,
| if you enter 3.67 in a cell, both the display and the underlying value
become
| 3.7.
|
| At least this is the way it's supposed to work. Somebody somehow managed
to
| get the 3.67 value into a cell (entering into another cell, copying and
| pasting?), the cell displays as 3.7, but it calculates on the 3.67.
|
| I can sort of understand how the underlying value might show as 3.67, but
I
| definitely can't understand why PAD isn't overriding the calculation since
| it's displayed as 3.7.
|
| Is there an additional safeguard I could deploy, or is this just one way
| that Excel isn't perfect? TIA.