Blackmist comments on when you import some data into Excel and it tries to format all your number fields

submitted 2 years ago by Agent641@lemmy.world to c/programmerhumor@lemmy.ml

you are viewing a single comment's thread
view the rest of the comments

[–] Blackmist@feddit.uk 20 points 2 years ago (1 child)

Nice barcode you have there. Be a shame if somebody took any leading zeroes off.

Nice Int64 you have there. Be a shame if somebody rounded it to 14 significant digits.

[–] wizardbeard@lemmy.dbzer0.com 3 points 2 years ago*

Import from the data tab, force all columns as text formatting. Excel won't fuck with the formatting then.

parent

lemmy:	0.19.20
mlmym (mschae):	26.3.4