The Incredible Mr. Limpet (1964)

A wimpish bookkeeper with a passion for sea life slips off a pier and comes back as a fish. He then helps the Navy track down German U-Boats.