i have a question:
when i import my text file into excel it shows the degrees as 32.245563223 (this is NOT decimal degrees...it is degrees minutes seconds)
i need it to be displayed like this: 32°24'55.6"
what would the number format code be to show this?
can you please help...
thanks,
stark
when i import my text file into excel it shows the degrees as 32.245563223 (this is NOT decimal degrees...it is degrees minutes seconds)
i need it to be displayed like this: 32°24'55.6"
what would the number format code be to show this?
can you please help...
thanks,
stark