...
- Be sure that there are no spaces before or after your values. ArcMap tries to read these as part of the value field.
- All null/empty fields must be converted to 0.
- ID numbers must be in General format - no numbers or text
- If your numbers are formatted as General, but are left justified, Excel is storing them as text. These will not import properly into ArcGIS. To fix this problem, do the following:
- In an empty cell of the spreadsheet, type the number 1
- Copy the cell with the number 1 you just created
- Highlight all of the General cells with text formatting - they will be left justified.
- Go to the Home tab, click on the black arrow underneath the Paste button and choose Paste Special. The Paste Special dialog box will appear.
- In the Paste Special dialog box under the Paste options, choose Values. Under the Operations options choose Multiply.
- Click OK.
- If your numbers are right justified and the cells are formatted as General, they should be able to be used properly as ID numbers in ArcGIS
- If your numbers are formatted as General, but are left justified, Excel is storing them as text. These will not import properly into ArcGIS. To fix this problem, do the following:
- make sure all values for quantities are formatted as numbers. You must preserve leading zeros.
- if error message for number stored as text, change so that this error message no longer occurs.
- Everything formatted as general shows up in ArcCatalog as Double
...