Re: Ah, Excel sorting
>Most spreadsheets (including Excel) allow you to modify the format of a column (/row/cell) to allow it to keep the leading zero. It's up to the user to pick the appropriate format themselves.<
But that's only temporary formatting. Try saving it as a CSV, ready to import into something else - then decide you need to edit a little more. When you open that CSV in Excel the leading zeros are all gone
Biting the hand that feeds IT
