use =int() function
The *Int* function returns the integer portion of a number.
On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac michelle.maccrac...@nmss.orgwrote:
I am exporting a file from online which automatically includes dates.
This interferes with my Pivot tables. How do I convert an entire
Hi Mich Mac,
It's better if you provide some sample data in excel file, so that we can
suggest you the exact formula to your expectation.
---
Ms.Exl.Learner
---
On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac michelle.maccrac...@nmss.orgwrote:
I am exporting
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.
--
--
Some important
Try this function :
date(year(yourdate),month(yourdate),day(yourdate))
text(yourdate,dd/mm/yy)
you can go for custom date format in format cell option
another way to do this ,insert a column after date column and use
text to column put a space character in delimite
On 16/09/2011, Shaik