February 15, 2021

Leading Zeros in Excel vs. Modern CSV

Everyone knows that disappearing leading zeros in Excel is a problem, yet Microsoft never bothers to address this. It is a giant headache, but Modern CSV will never ever ever do that to you, promise! Here are some visual aids with bad fake data. Excel hides leading zeros Modern CSV always shows them Leading zeros in all their glory (oh yeah, plus Modern CSV has a dark theme, which Excel doesn’t because Excel is old). Adding leading zeros in Excel Now, what if you want to add leading zeros in Excel? Say, every number should be 10 digits long and […]