Create your own formula to convert the degrees, minutes and seconds used in geography to a decimal number. DMS map coordinates consist of whole number degrees that are divided into 60 minutes.

Enter the decimal measurement in cell A1 of Microsoft Excel. As an example, enter "5.792" in cell A1. Enter "=RoundDown(A1,0)" in cell B1 to extract the number of feet.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

Q. Thanks for your advice in the September 2001 issue on converting fractions in Excel into decimal values. ... Highlight the decimal numbers you want to convert to fractions and then right-click, ...

Learn about and revise how to convert between fractions, decimals and percentages with this BBC Bitesize GCSE Maths Edexcel study guide.