Formatting latitude and longitude numbers

[toddb511]

Hi all,

I am having difficulty finding the difference in kilometers between 2 sets of lat/long. The problem seems to be with the way the numbers are formatted. Excel indicates a formatting issue but the custom format is not working for all cells. The custom format I would like to use is: ##.######## (2 numbers [DECIMAL] 8 decimal spaces).

I have a formula in cell F but because the numbers aren't formatting correctly, the formula is not working for all cells. How can I have excel follow this format for all cells and make the formula work?

Please let me know if anything is unclear. Thank you for your assistance!!