Re: Indirect and Address problem (SOLVED)
haven't had my first cup of coffee. On 10/3/2013 12:41 PM, Brian Barker wrote: At 12:14 03/10/2013 -0600, John Meyer wrote: Okay, so I just needed one more step with Brian's problem. Er, I don't remember having a problem! ;^) When I imported the date from the web site, it also had the time portion. So, I created another column and put a formula of QUOTIENT(B2;1) ... INT(B2) might be easier. ... and formatted that as a date. I'm not sure formatting will make any difference here. Voila, it works. Good-oh! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Indirect and Address problem (SOLVED)
At 12:14 03/10/2013 -0600, John Meyer wrote: Okay, so I just needed one more step with Brian's problem. Er, I don't remember having a problem! ;^) When I imported the date from the web site, it also had the time portion. So, I created another column and put a formula of QUOTIENT(B2;1) ... INT(B2) might be easier. ... and formatted that as a date. I'm not sure formatting will make any difference here. Voila, it works. Good-oh! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Indirect and Address problem (SOLVED)
Okay, so I just needed one more step with Brian's problem. When I imported the date from the web site, it also had the time portion. So, I created another column and put a formula of QUOTIENT(B2;1) and formatted that as a date. Voila, it works. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
