Yes, Sam, absolutely right! Sorry, everyone.
On Sep 17, 2:10 pm, Sam Mathai Chacko wrote:
> Steve, a modification. shouldn't it be =ROUNDDOWN(yourdate,0)
>
> On Sat, Sep 17, 2011 at 6:35 PM, lifescholar
> wrote:
>
>
>
>
>
>
>
>
>
> > round(yourdate,0)
>
> > On Sep 15, 9:09 pm, Mich Mac wrot
Steve, a modification. shouldn't it be =ROUNDDOWN(yourdate,0)
On Sat, Sep 17, 2011 at 6:35 PM, lifescholar wrote:
> round(yourdate,0)
>
> On Sep 15, 9:09 pm, Mich Mac wrote:
> > I am exporting a file from online which automatically includes dates.
> > This interferes with my Pivot tables. H
round(yourdate,0)
On Sep 15, 9:09 pm, Mich Mac wrote:
> I am exporting a file from online which automatically includes dates.
> This interferes with my Pivot tables. How do I convert an entire
> column of dates with the time to dates without the time.
--
---