If I understand correctly, you have one column with decimal longitudes, and one column with decimal latitudes?

If so, just add a third column that is the negative of the (incorrectly) positive longitudes.

Eg. C1 = -A1, etc.


Richard

__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
See the Geoweb Guru for online mapping