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.

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time ...

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.