[bussiere]

I have worked several times on serveral projects with excel files containing barcode number like 0754...

And someone in the process open the file, and hop excel remove all the zero at he beginning fo the number

I've lost a lot of time from this...

[rzzzt]

Add a ' prefix to them so they are treated as text. We've had problems with many-digit integers being converted to floating point approximations instead.

[master-lincoln]

How did people keep up with that? Is there really no competitor who gets this right? These unexpected conversions must have cost billions in problems they created or fixing time they needed. And now after so many years they just remove some types of auto conversion and leave the others? Sounds like some kind of Stockholm syndrome...

[Maxion]

Once you’ve done this read in the data into Python or JavaScript and upload it to a backend.

Fun.

[Gelob]

That's stupid and when I export to csv it has a '. Excel should just stop fucking with shit

[mulmen]

Adding a prefix breaks any other process that might read that data.

[Tagbert]

Set the column/cell format to “text” and it will retain what you typed.

[Gelob]

That doesn't work