Spread sheet formula for DMS and DD

[froggy1]

Hello,

This is my first time.
first of all, I am looking for a spread sheet formula to convert
for example 53°32'53" (this is how it is on the spread sheet already, I believe in text format), to decimal degrees.

Secondly I would like a spread sheet formula to convert for example 53.5517 decimal degrees to 53°33'06"

Thank you

 

[sdruley]

function deg_to_dms ( degfloat )
Input must be non-negative: if degfloat < 0 error end if Compute degrees, minutes and seconds: deg ← integerpart ( degfloat ) minfloat ← 60 * ( degfloat - deg ) min ← integerpart ( minfloat ) secfloat ← 60 * ( minfloat - min ) Round seconds to desired accuracy: secfloat ← round( secfloat, digits ) After rounding, the seconds might become 60. These two if-tests are not necessary if no rounding is done. if secfloat = 60 min ← min + 1 secfloat ← 0 end if if min = 60 deg ← deg + 1 min ← 0 end if Return output: return ( deg, min, secfloatthis could be mend function

</pre>

ref
this function can be referred to within a cell

 

[froggy1]

ref
this function can be referred to within a cell

Thanks for your time!

 

[froggy1]

I have found this formula, that works great, to convert deg min sec to decimal degrees when the number format is
53 32' 53"

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A3)," ",":"),"'",""),CHAR(34),"")*24

what I am looking for is how should this formula be written to take into consideration the ° sign?
as in converting 53° 32' 53" to decimal degrees. Can it be done?
Any help would be appreciated!