GPS and Excel

[Hommie]

Trying to enter in GPS into Excel with the following NumberCustomFormat. My aim is to just type in the code and it gives me the decimals.

Custom dormat is : ###""##"."###

The problem is that it is leaving out the period after the 5th digit. I know I have to do the ALT+0176 to get the degrees symbol.

I would like to just put 25 (ALT+0176; for the degrees) 05895.

It would look like 25°05.895

Any answers would be apreaiated.

Thanks in advance.

 

[Smitty]

How about a formula, so you can just enter the numeric postion:

=LEFT(A2,2)&"°"&MID(A2,3,2)&"."&RIGHT(A2,3)

HTH,

Smitty