Page History

...

1. Be sure that there are no spaces before or after your values.  ArcMap tries to read these as part of the value field.
2. All null/empty fields must be converted to 0. 
3. ID numbers must be in General format - no numbers or text
   1. 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:
      1. In an empty cell of the spreadsheet, type the number 1
      2. Copy the cell with the number 1 you just created
      3. Highlight all of the General cells with text formatting - they will be left justified.
      4. 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.
      5. In the Paste Special dialog box under the Paste options, choose Values.  Under the Operations options choose Multiply.
      6. Click OK.  (Adapted from http://en.allexperts.com/q/Excel-1059/Excel-Cell-Format-Issue.htm^{Image Added})
   2. 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
4. make sure all values for quantities are formatted as numbers.  You must preserve leading zeros.
5. if error message for number stored as text, change so that this error message no longer occurs.
6. Everything formatted as general shows up in ArcCatalog as Double

...