QUANTSLANT_
AI Tools

Keep leading zeros in an Excel CSV import without changing IDs

quantslant@ai:~$ cat news_1

› Import identifier columns as Text before Excel converts them into numbers.

quantslant@ai:~$ cat news_2

› A custom display format can make a value look padded with zeros, but it cannot recover digits that disappeared during an earlier conversion.

quantslant@ai:~$ cat news_3

› An identifier is a label, even when it contains only digits I decide the type of a column from its purpose, not its appearance.

quantslant@ai:~$ cat news_4

› A quantity is a number because adding quantities has meaning.

quantslant@ai:~$ open --full
Read more

Keep leading zeros in an Excel CSV import without changing IDs

Open article on quantslant.com