Oh, yeah... I forgot to mention... when you have the complete list of "formula" based values... you will then want to highlight and copy the whole column. Then "Paste Special" and set the output to "values". This pastes the data back in with only values and no formulas. Insert column next to matched numbers (eg. 33) and clean out the rest.
Mark Scholmann ----- Original Message ----- From: "Mark Scholmann" <[EMAIL PROTECTED]> To: "WAMUG Mailing List" <wamug@wamug.org.au> Sent: Friday, 26 September 2003 11:55 Subject: Re: help with excel > 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 > > > > > -- 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 >
