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 wrote:
> I am exporting a file from online which au
use =int() function
""The *Int* function returns the integer portion of a number.""
On Fri, Sep 16, 2011 at 1:39 AM, 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
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 Wah
Well, u can "use text to columns" wizard and follow the steps, to split it.
On Fri, Sep 16, 2011 at 1:39 AM, 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
