top | item 37983557

(no title)

bussiere | 2 years ago

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...

discuss

order

rzzzt|2 years ago

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|2 years ago

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|2 years ago

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

Fun.

Gelob|2 years ago

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

mulmen|2 years ago

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

Tagbert|2 years ago

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

Gelob|2 years ago

That doesn't work