Re: $$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread lifescholar
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

Re: $$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread Sam Mathai Chacko
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

$$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread lifescholar
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. -- ---