Copy the line below to Format - Cells - Number - Custom and place line in box
at top of Form.

00°00.000

"Mike" wrote:

How do I format a column or cell for entering Latitude & Longitude data.
Most of the data I have is degrees, minutes & seconds "nn°nn.nnn" North
Latitude by "nnn°.nn.nnn" West?
--
Tnx,
Mike