22 ms·
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
by roxgib 4y ago
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.
- codetrotter 4y agoIt 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.