Converting a string of numbers to decimal
 

divide by 1000?
put 1000 in a cell somewherecopy that cellselect all of the cells to
changeeditpaste specialdivide

--
Don Guillett
SalesAid Software

"avb1958" wrote in message
...
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.