I need to write a huge pandas dataframe from Python to Excel. Among others, it has fields in which there are random alphanumeric combinations, like 1234E324. When writing to Excel, xlwings converts ...

However, when I go to reformat them, Excel -insists- on converting the number to scientific notation--and since I'm editing the string into a non-number format (multiple spaces, parenthesis, etc ...

String values like "709223E4","135087E6","135087E5" which starts with digit and end with E0, E5, E6 etc. get converted into number. For instance, "709223E4" gets converted into number 7092230000 and ...