Chris, try this -
if you had the numbers in A1 = 32 and B1 = 118 then in C1 put this formula - =VALUE(A1&"."&B1) Then copy down against all other numbers and the result will be a concatinated number value. Also, in the formula change the cell references to where ever the numbers are. Cheers, Mark Scholmann ----- Original Message ----- From: "Chris Burton" <[EMAIL PROTECTED]> To: "WAMUG Mailing List" <wamug@wamug.org.au> Sent: Friday, 26 September 2003 11:47 Subject: help with excel > Hi everyone > > I have a dilemma with hundreds of records of gps data. It has been > entered in 3 columns as > Degrees, Minutes and Seconds: eg 33 32 118 Unfortunately I > think it should have been in two columns as: > Degrees and decimal minutes: eg 33 32.118 > > Can someone please assist with a short cut to tell excel to add the > decimal point and the seconds column to the minutes, so I dont have to > go through and retype each record? Blowed if I can think of the > solution here, and the help is not that intuitive. I have thought of > the Concatenate function but it deals with text...is there another that > will use numbers and dots! > > thanks for any help > > chris > > > -- The WA Macintosh User Group Mailing List -- > Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> > Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> > Unsubscribe - <mailto:[EMAIL PROTECTED]> > > WAMUG is powered by Stalker CommuniGatePro >