Check if last character is equal to - Excel

I'm currently using this formula which isn't working:

=IF(RIGHT(TRIM(L3),1)=4,1,0)

The value in L3 is 4, and so I would expect it to return a 1, not a 0, however I am getting the 0 returned from the if statement.

Could someone explain why this is happening?