Even if you set the data format to 'currency' it still returns false (in Google Sheets). I realise they probably want consistency but it's weird they don't have an option to use a decimal type.
It is my impression of most spreadsheet software that the “data format” is more about display, and not about actually strongly typed representations of the data.