Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract decimal numbers e.g. $1.57 from alphanumeric string | Excel Discussion (Misc queries) | |||
Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
Converting String numbers into real numbers | Excel Programming | |||
Converting String numbers into real numbers | Excel Programming | |||
How do I enter a decimal in a string of numbers in Excel? Example. | Excel Discussion (Misc queries) |