Converting Bianary Type Date from MSSQL to date in Excel

[Demaestro]

Hello all,

Currently I have a spreadsheet exported from a MSSQL database. The date fields are stored in a binary format. An example of one of the values is:
CAST(0x00009F8F00000000 AS DateTime)

In MSSQL that converts to:
2011-11-02 00:00:00.000

The size of the date is quite large and I don't think running it into MSSQL and back out will work (but I am willing to try)

I am just wondering if I strip out the CAST AS DateTime and just leave the binary value is there a way to convert these into dates within Excel?

Basically I need to convert this to a date:
0x00009F8F00000000

Any help is greatly appreciated. Thanks.

[JieJenn]

Can't you just do double cast in SQL Server?

SELECT CAST(CAST(0x00009F8F00000000 AS DATETIME) AS DATE)

[Demaestro]

Hi JieJenn

It converts in MSSQL my issue is that I have a couple spreadsheets with this data in cells and they appear in multiple columns. I am hoping to avoid putting the data back into a db and then exporting. Ideally I would be able to do this right in the cell with some sort of function.

[JieJenn]

check your text to column; i think you might have checked separated by semicolon.

[JieJenn]

Or post your excel spreadsheet.

[Demaestro]

forum_example.xlsx

Here is a file with the column in it.

Thanks again in advance for your time.