Differences

This shows you the differences between two versions of the page.

--- general:pmis_excel_formatting_instructions [2018/11/26 19:46] – created emoreno
+++ general:pmis_excel_formatting_instructions [2021/03/25 14:25] (current) – emoreno
@@ Line 1: / Line 1: @@
-Format Columns
+<div head3> Format a Column in Excel</div>
-To enter leading zeroes, in your spreadsheet click on Home and then the dropdown next to “General”
+<WRAP round intro>
+Use the following steps to format a column with leading zeros.
+</WRAP>
-Click on “More Number Formats”
+VCV In the Excel spreadsheet, click **Home** and click the drop-down arrow next to **General**.
+VCV Select //More Number Formats//. The Format Cells pop-up window opens.
+VCV Under **Category**, select //Custom// and then under **Type**, highlight the word **General** and type the number of zeros that represent the number of characters required for the field. For example, the **Employee Number** must be six characters with leading zeros, so you would type six zeros.
+VCV Click **OK** to save the changes.
-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”.

Business