Sidebar
general:pmis_excel_formatting_instructions
This is an old revision of the document!
Format Columns
To enter leading zeroes, in your spreadsheet click on Home and then the dropdown next to “General”
Click on “More Number Formats”
Click on “Custom” and highlight the word “General”
Fill in the number of zeroes you need to represent the field. For example, employee number must be 6 characters with leading zeroes, so you would type in 6 zeroes. Click “OK”.
general/pmis_excel_formatting_instructions.1543261592.txt.gz · Last modified: 2018/11/26 14:46 (external edit)