orthogonal to topic of this post:
SI dictates that there’s always a space between the number and the unit of measure. including for n °C and n °F.
its really common to see the space between the number and the unit (°C) omitted in writing around climate change with all the all commentary in mainstream media about 1.5 °C and 2.0 °C “thresholds” for tipping points etc etc. but it’s bad grammar to omit the space.
see the General Rules section of this his page.
https://en.m.wikipedia.org/wiki/International_System_of_Units#
ps
anks to Simon Petyon Jones and all those at MS who work on bring FP to Excel. it desperately needed it and is one reason even non-coders are turned of Excel formulae they very quickly become ugly as sin and as debuggable as nonsense. for me as a novice Haskell coder this is an invitation to give Excel another chance for serious work.