it might. Just got time for a quick test before I have to self-isolate as a 'person at risk'. A colleague has just found out somebody at a function she attended last week has been diagnosed with COVID19 so as I'm a cancer survivor I've been asked to work from home.

Anyway, changing the function didn't improve things, I suspect it's the correct variant value that I can't find.

Set ComValue of oGLKYRange OLEXLRangeValueDefault to "105E07"
Set ComNumberFormatLocal of oGLKYRange OLEXLRangevalueDefault to OLExlTextWindows //OLExlText //OLExlTextFormat //"@"