[MichaelGG]

I've found it hard to get Excel to turn off the coercions. In telecom tons of inter-company data is exchanged in Excel or CSV files. And very often numbers show up in scientific notation. Or timestamps (10.2 minutes) get coerced into dates. It's infuriating. Sometimes the manual formatting to no format works and sometimes it doesn't. I feel dumb admitting that I can't seem to figure something so basic out.

Excel should really offer an easy way around this.

[brodie78382]

My experience is the same, also in telecom/networking. One of our vendors' serial numbers, when entered into Excel, get converted to something else entirely (not sure what exactly), and setting the fields to "text" or "numbers" doesn't seem to do much, consistently.