Wrong date format when export to Excel

[#1]

Hello

when I just use date field from Dimension and export the table to excel everything working well.

but as soon that I am using a formula

=if(date> actual,date)

When Actual is a variable ==> 1/2/2015

and export to excel than the format in excel not ok.

I mean when I am filtering the date I don't see group like we should see for date "Year / month and than date"

but I see a lot of lines of date, You can see the picture attached.

I don't know what to do.

I hope that it was clear

thanks

Franck

[m_woolf · Accepted solution]

Your dates are coming into Excel formatted as Text.

To convert in Excel, click column A and chcnge the format to Short Date.

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

     If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

     Or

     Right-Click and Export to csv. Then open in Excel.

[#3]

THANKS A LOT

I was stuck with this during a long time,

HAVE a very nice weekend and thank you again