Thread: Custom Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Custom Format

I need a custom format for latitude/longitude. Currently I have it as ## ##.##

If possible, I would like the degrees symbol (superscript little circle) to
be displayed after the first two ##.

Next question: I need to be able to pull the format apart to calculate the
great circle distance. I need to be able to pull the degrees (first ##) and
the minutes (##.##). How can I do this?

Thanks,
Les