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
general:pmis_excel_formatting_instructions [2019/02/08 21:14] emorenogeneral:pmis_excel_formatting_instructions [2021/03/25 14:25] (current) emoreno
Line 7: Line 7:
 VCV In the Excel spreadsheet, click **Home** and 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.1549660472.txt.gz · Last modified: 2019/02/08 16:14 (external edit)