6 ms·
I've never had to use JavaScript, but I've done the *1 or &"" in Excel to force conversion to the desired type... yes, let's mercifully lay the veil of forgetti
by FabHK 6y ago
I've never had to use JavaScript, but I've done the *1 or &"" in Excel to force conversion to the desired type... yes, let's mercifully lay the veil of forgetting over this.
- franga2000 6y agoConsidering Excel's offical way of writing a != b is a<>b, I think these kinds of hacks there can be excused :)
- uncanneyvalley 6y agoa<>b is the preferred syntax in SQL. I'm pretty sure a!=b works everywhere these days, but that hasn't always been the case. (eta: didn't finish the thought - I'd assume SQL influenced Excel, since it's older.)