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????

Thanks,

Jane

Hi Jane - It may have something to do with that column. How did you add the '-'? The only way I've had that work in the past is to use a '-1' multiplier to get the number format to stick. There's a chance your process converted the numbers to text.

-Adam Z