Creating points from excel/access

[NicoleHanson]

I'm trying to create points from the excel/access table.  I have Lat/Long, and they are in a format like: 462508 for Lat and 1163445 for Long.  It's not creating a shapefile that I would expect.  Is there any way to calculate these values into Decimal Degrees?

[michaelcollins1]

Looks like your coordinates are UTM based (or something similar). Create your shapefile using the proper UTM zone, then pop it onto your map, then create 2 new fields for LAT and LON and populate them using Calculate Geometry

[NicoleHanson]

What would the calculation be for the new fields?

[michaelcollins1]

Check this out:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s00000027000000

[NicoleHanson]

OK, I did that, but it seems to be shifted from other data I have in ArcMap.

[michaelcollins1]

Shifted by how much? Perhaps you used NAD83 instead of NAD27 or vice versa.

[NicoleHanson]

It was more of a spreading and shifting. 

I asked a coworker for some help, he knows python, and he was able to get the data changed to DD.  Thanks for your help.