I second what Mitch has said. Also, what type of data are you trying to make? A shapefile? Geodatabase?
Another thing you can do is, in Excel, be sure the entire data column is set to be numeric. Format the cells for the entire column and select Number for the category