Excel formula

Question

In Excel, I used to use CONVERT_degree **(cell Number)**to convert a decimal angle into Degree, minutes and seconds. Is there a new way to convert this as my excel program has been migrated to a windows 10 machine with office 365 and doesn't seem to work anymore?

Many Thanks

Answer 1

Thanks so much, working well. Yipee!

Answer 2

To:  GordonTodd1

re:  code supplied by MS

The author of that code must be a member of the Windows10 coding group.

Try this modified version of the code.

Note: the function name has been changed.

'---

Public Function CONVERT_DEGREES(ByRef Decimal_Deg As Variant) As Variant

'Revised 11/06/2019 - Nothing Left to Lose

Dim Degrees As Double

Dim Minutes As Double

Dim Seconds As Double

  'Set degree to Integer of Argument Passed

   Degrees = VBA.Int(Decimal_Deg)

   'Set minutes to 60 times the number to the right

   'of the decimal for the variable Decimal_Deg

   Minutes = (Decimal_Deg - Degrees) * 60

   'Set seconds to 60 times the number to the right of the

   'decimal for the variable Minute

   Seconds = VBA.Format(((Minutes - VBA.Int(Minutes)) * 60), "0")

   'Returns the Result of degree conversion

   '(for example, 10.46 = 10~ 27  ' 36")

   CONVERT_DEGREES = " " & Degrees & "° " & VBA.Int(Minutes) & "' " & Seconds & VBA.Chr(34)

End Function

'---

Excel programs (now free) at MediaFire...

(the 'custom_functions' add-in provides 20 new excel functions)

http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Answer 3

Hi pasted the VB code into the Module as instructed but did not solve the issue.

We have migrated to Windows 10 and office365 and the workbook it was written on does not work. (#NAME?)

Answer 4

It sounds like the UDF (user defined function) has gone missing.

Here is a link that will guide you through restoring it..

https://docs.microsoft.com/en-us/office/troubleshoot/excel/convert-degrees-minutes-seconds-angles