openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: Indirect and Address problem (SOLVED)
Date Thu, 03 Oct 2013 18:41:48 GMT
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


Mime
View raw message