Converting a string of numbers to decimal
How about if you divide them by 10,000? Put 10000 some where on the
spreadsheet, copy it, then edit - paste special - divide over the
records.
Ken
avb1958 wrote:
I have a problem. I have a spreadsheet with latitude and longitude that for
some reason were not put in decimal format. I need to convert these numbers
to a 4 place decimal value. Can this be done and, if so, how do I do it?
Example: Lat Long
445804 -731725
These need to be converted to:
44.5804 -73.1725
I have over 12,000 records and am trying to import this data into Streets &
Trips.
Any ideas?
Thanks.
|