Skip to content

Question about precision

Created by: neters

The excel file has a cell which value is "20.1". But when I read it, its value shows as 20.100000000000001.

I've tried to set this cell's format as "text", but this problem still exist.

So how should I read this kind of cell to handle the precision problem?