Florin,

Nice to hear that Perth is getting a mention.

Look at http://www.cpearson.com/excel/latlong.htm for lots on tips on
this type of conversion to/from DMS.


--
Kieran

Born ignorant and still perfecting the art
------------------------------------------------------------------------
Kieran's Profile: http://www.excelforum.com/member.php...fo&userid=1247
View this thread: http://www.excelforum.com/showthread...hreadid=277622