openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Meyer <johnme...@pueblocomputing.com>
Subject Re: Indirect and Address problem (SOLVED)
Date Thu, 03 Oct 2013 18:41:36 GMT
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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message