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 [2018/11/26 21:55] emorenogeneral:pmis_excel_formatting_instructions [2021/03/25 14:25] (current) emoreno
Line 1: Line 1:
-===== Format a Column in Excel =====+<div head3> Format a Column in Excel</div>
  
 <WRAP round intro> <WRAP round intro>
Line 5: Line 5:
 </WRAP> </WRAP>
  
-  - 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**.  
-  Select //More Number Formats//. The Format Cells pop-up is displayed.  + 
-  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 Select //More Number Formats//. The Format Cells pop-up window opens.  
-  Click **OK** to save the changes. + 
 +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. 
  
  
general/pmis_excel_formatting_instructions.1543269316.txt.gz · Last modified: 2018/11/26 16:55 (external edit)