I have an excel (office 2007) table with x, y lat/long data. I add the table to my map, and right click it in the table of contents to "Display XY Data...", but the dropdowns only show my "Name"column (my names are numbers). I figured out that this is because arcmap isn't recognizing the data in the x and y columns as numeric, even though I did go into excel and specify them as such. Is there a way to fix this? How can I change them so that arcmap recognizes them as numeric?
Thanks in advance for any help. I just started learning gis recently, and got arcmap 10 only a week ago, so this is all very new to me.