In my school district our student ID numbers begin with zeros. This is a problem in spreadsheet software like Google Sheets or Microsoft Excel because by default you can’t include the leading zeros in a cell. There are a few ways to change the cell formatting to include leading zeros in the cell so that your student ID numbers or other data looks correct in your spreadsheet.
Read more...