RE: Out of Office AutoReply: help with excel
whoops sorry, sorting now... sTEVE > -- > From: Neil Houghton > Sent: Sunday, September 28, 2003 9:25 AM > To: WAMUG Mailing List > Subject: Re: Out of Office AutoReply: help with excel > > on 28/09/03 09:16, Steve Fellows at [EMAIL PROTECTED] wrote: > > > Thank you for your email. > > Dear all > > > > I am away for some much needed annual leave, and arrive back to work on > the > > 20th of October. > > > > If you have a IT query please, as always, call 7444 or email ADS first, > not > > my mobile (ADS in Outlook, or [EMAIL PROTECTED]). > > > > > > sTEVE > > Hi Matt, > > Can this email address be suspended from the Wamug list till Steve gets > back > on 20 Oct - otherwise every wamug message will get this auto-reply to the > originator? > > Thanks > > Neil > -- > Neil R. Houghton > Albany, Western Australia > Tel: +61 8 9841 6063 > Fax: +61 8 9841 6137 > Email: [EMAIL PROTECTED] > > > -- 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 > >
Re: Out of Office AutoReply: help with excel
on 28/09/03 09:16, Steve Fellows at [EMAIL PROTECTED] wrote: > Thank you for your email. > Dear all > > I am away for some much needed annual leave, and arrive back to work on the > 20th of October. > > If you have a IT query please, as always, call 7444 or email ADS first, not > my mobile (ADS in Outlook, or [EMAIL PROTECTED]). > > > sTEVE Hi Matt, Can this email address be suspended from the Wamug list till Steve gets back on 20 Oct - otherwise every wamug message will get this auto-reply to the originator? Thanks Neil -- Neil R. Houghton Albany, Western Australia Tel: +61 8 9841 6063 Fax: +61 8 9841 6137 Email: [EMAIL PROTECTED]
Re: help with excel
on 26/09/03 11:47, Chris Burton at [EMAIL PROTECTED] wrote: > 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 118Unfortunately 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! > Hi Chris, Forgive me for stating the obvious, but if the data really is in degrees/minutes/seconds and you want it in degrees/decimal minutes then you will need to actually convert it - ie divide seconds by 60 to get decimal minutes and then add to the whole minutes. However, from the example you give I'm assuming this is not the case (since 118>60 and the max you'd expect in the seconds column would be 59). So assuming the data in the second two columns IS minutes/decimal minutes your options depend on how the data is entered in the third column with respect to leading/trailing zeros, eg how would say .200, .020 and .002 minutes have been entered in the third column: - if just the digits after the decimal point have been entered, you would have a problem since "2" "02' and "002" will all equate to 2 and I suspect you would have to go through and retype the records to get the correct values. - assuming all three digits (including leading/trailing zeros) have been typed in ie "200" "020" "002" the number will be correctly entered as thousandths ie "200" "20" "2" and you can just do a conversion. 1) type "=RC[-2]+RC[-1]/1000" in column 4 (fill down to cover all records) 2) select and copy column 4 3) "paste special" into column 5 and paste "values" 4) delete columns 2,3 & 4 (a quick alternative would be to just do step 1 and then hide columns 2 & 3) Hope that helps. Cheers Neil -- Neil R. Houghton Albany, Western Australia Tel: +61 8 9841 6063 Fax: +61 8 9841 6137 Email: [EMAIL PROTECTED]
Re: help with excel
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" 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" > 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 118Unfortunately 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 >
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" 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 118Unfortunately 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 >
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 118Unfortunately 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