Arizona Unemployment Tax and Wage System
Employee and Wage File Upload Instructions Required Format
How to format a column in Excel to accept, display and retain data as text:
All number columns in your file should be formatted as text.
Step 1. Open or create the wages file using Excel and key data into the four required columns. See Figure 1 below.
Figure 1.excel
Step 2.
Highlight the desired column by moving your cursor over the header of the cell (A in this example). Doing this will cause the cursor to change to a + sign, click your left mouse button once. The whole column should highlight. See Figure 2 below.
Figure 2.excel
Step 3.
Open the menu item Format-Cells. Select the Number tab. Select “Text” from the Category list. See Figure 3 below. Click Ok. Column A is now formatted for “Text.” It is recommended that the Social Security Number, Total Wages and Excess Wages columns be formatted in this manner. If the Social Security Number column is not in the “Text” format, there is a possibility that any leading zeroes in the Social Security Numbers will be lost during the conversion. It is also very important to note that the Taxable and Excess Wages columns cannot have dollar signs or commas.
Figure 3.excel
Login to the Tax and Wage System
Related Topics: