if more than 2 decimal places
Thanks for responding Cliff
The cell is set to display as 2 dp but the underlying value may have more
decimal places. I want to check if the underlying value has more than 2 dp.
I have trying to code something like
if cell.value < int(cell.value *100) / 100
and this does work on most occasions but sometimes I get a unexpected result.
g
"ward376" wrote:
Do you mean two places displayed in the cell, or two places in the
underlying value?
Cliff Edwards
|