yogi_ Convert Longitude In Degrees And Minutes To Degrees and Thousandths Of Degrees

                                          Google Spreadsheet   Post  #1419
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 13, 2013
question by superflycasanova (http://productforums.google.com/forum/?zx=3p34c7g6hlry#!category-topic/docs/spreadsheets/wDa38owgrAE)
converting a degree and minute longitude to a decimal degree longitude
I've got a list of longitudes that look like this in a spreadsheet

40°55.26 N

and I want to convert them to decimals

40.921

Is there a way of automating this procedure e.g. take the numbers before the ° add the decimal point and then add the numbers after the °/60 (and get rid of the N)?

-----------------------------------------------------------------------------------------------------------------------------