View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
gbink gbink is offline
external usenet poster
 
Posts: 4
Default 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