I have a spreadsheet with the coordinates in DD. The Longitude numbers did not have a - in front. For example 114.235 not -114.235. So I added another column named Long and added the -. I then tried to import the data into arc map using add data xy but the Long column does not show up as one of my options in the add data xy box. I am assuming it has something to do with the original Longitude columns formating????