Issue with Formatting Date Column with Data Extract from SQL Server

I am having an issue with formatting a column from data that I have brought down from SQL Server 2012 (see attached file).

The data on SQL Server was datetime2(7) although I've also tried just date.

I changed the format in column A to "Date, 14-Mar-12". Nothing changes. However, if I just put my cursor in the formula bar and then move to another cell, the previous cell changes to the correct format.

I am using Excel 2013

Any help on this bizarre behavior is much appreciated.

Jim

I don't know what kind of a query you have but try multiplying the date modified by 1. E.g.

Please Login or Register  to view this content.

This *might* work. It may force the date modified to a number which Excel will translate back into a date of the format specified.

A manual process that does work on the Excel side is to put a 1 in an unused cell. Format this to the date format you want (it will read 1-Jan-00). Then copy this cell and highlight the range of dates. Then paste special and check the box "Multiply."

Thanks dflak

I can try to add another column to the view that gets extracted with the multiply by 1. Problem is, this is a static Excel file that we have that users can use to extract the data from SQL Server. We dump 8 tables into a single Excel file. Only issue is this darn date problem.