If you have a string with numbers and the letter E then both programs will treat this as a number in exponential notation.
For example, the string 229E10 will be converted to 2.29E+12
What makes it worse is that you cannot change it back to the original text using the cell format options.
I run into this problem with strings that represent microtiter plate and well assignments. For example, 229E10 refers to plate 229 row E column 10.
I just want the spreadsheet program to take what I give it as text. Putting the string in single or double quotes can work but then the value remains in quotes in the spreadsheet.
The best way to do this seems to be to use double quotes around the string AND prefix that with an equals sign - like this:
For reasons that I do not understand, Excel will strip the extra formatting off the string and treat the contents as plain text. This also works for arbitrary strings, such as ="ABC"