RIGHT function bug

[HAES]

A cell contains the value 1.0
When I do a RIGHT function in this cell (e.g A1 contains 1.0; in A2: =RIGHT(A1;1)) it returns 1 instead of the expected 0
I can do make a workaround with: =RIGHT(A1*10;1), this returns the wanted 0

It seems that it has to do with something like deleting decimal 0's.
When the value = 1.2 then RIGHT returns the expected 2

Seems like a serious bug in EXCEL about handling decimal 0's.

[rorya]

It's not a bug. The value of the cell is 1 - the .0 is merely formatting.

[HAES]

Hi Rorya,

For me it's a bug because I want to filter on decimal values and 0 is also a value for me.
Now I get wrong results, but as I mentioned I can workaround with it by multilpying by 10,
but when I want to filter on the second decimal I've to multiply with 100 and so on

[rorya]

I'm sure it's inconvenient for you, but it's not a bug.

You could use =RIGHT(TEXT(A1;"0.0");1)