Date Problems

[Acropolis]

Evening All,

Been banging my head off a wall with this for hours now and it's stumping me completelt.

I hav a sheet which has a lot of data in it, there are sevral date columns, all these are formatted as short date, and when the data type is changed to general they all change to a serial version of the date, no problem here.

I have a second sheet, which has a data connection, not linked sheet but added a data connection and selected the appropriate sheet and it's added as a table in the second workbook. Some of the date fields come through absolutely fine and show as dates, and if I chage the data type in the table to general they change to the serial number for the date. However, some of them appear at the serial number of the date and alligned left in the cell, if i change the data type to Short Date, it makes no difference and they stay as a serial number.

This happens to the whole column rather than just some dates on that column. have been through and re-typed all the dates manually (twice!) and it fixed one of the cols but made no difference to the rest.

I've tried splitting the date out to the components (day, month, year etc.) and then using Date() to combine it back together, but no joy. I have tried with both the formula in the cell and with just the date in there.

Anyone have any suggestions?

Thanks

 

[steve the fish]

Well they sound like text. Try highlighting the column and pressing text to columns then finish.