User Tools

Site Tools


general:pmis_excel_formatting_instructions

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
general:pmis_excel_formatting_instructions [2019/02/06 23:35] emorenogeneral:pmis_excel_formatting_instructions [2021/03/25 14:25] (current) emoreno
Line 5: Line 5:
 </WRAP> </WRAP>
  
-VCV In the Excel spreadsheet, click **Home** and then click the drop-down arrow next to **General**. +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 is displayed+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 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.  
general/pmis_excel_formatting_instructions.1549496126.txt.gz · Last modified: 2019/02/06 18:35 (external edit)