So you're reading in the value and then comparing them? So probably as strings? (I suspect that depends how the cells in Excel are formatted)
In which case, my original answer stands, you're going to have to do some standardisation of the notation if you want a simple string compare to work. A bunch of "Replace" type statements would work, but it feels like there should be a more efficient way? But nothing is immediately coming to mind ....
Yes. You are right Colin.
I am also thinking for a different solution to solve this.
Thanks,
Karthik K R
