Need help in exporting log file of scanner with lat long

[chiku]

i have logfile with scanner rssi value.i need to export that in excel with lat long and rssi to compare with model.But when i export those log file ,i get result lat44.1 and long 69.44 just two decimal which points same area in map.if i export in text i get reult as lat N4406.2360 and long W 06926.2218.


So can some bodyhelp me how can i get degreee decimal values of above.

[onlygod]

In Excel you can do this to convert: N4406.2360 to 44.06236, where A1 is the cell:
=(RIGHT(A1,9))/100

If Longitude is: W06926.2218
Then you should use this: =((RIGHT(A1,9))/100)*-1
To get -69.262218