Lat/Long Conversion Help

[gunrock31]

I need to make this "34-20-15 " look like this " N34° 20' 15," anyone have any suggestions? i cant get the format painter to work here and im not too sure how to write a formula to create this.

thanks
matthew

[Flintstone]

Try this.

Format|Cells|Number,Custom

N##(Alt 176) ##' ##''

You need to press and hold the Alt key while entering 176 on your numbers key pad for the degree symbol ( ° ). And for the double quotes enter two single quotes ( ' ), it wont except the double quote.

Matt

[olasa]

I'd like to know how to convert Long/Lat to a X-Y position on a Mericator map? (I have City positions long/lat and want to put the Cities on a Mericator map X-Y position.
I tried to find a conversion formula - but so far without success.

Thanks for any help
Ola Sandström