Hi,
I have a data sheet which has one date column.
I formatted the entire column to be in date format.
Then, for some reason, I opened the sheet and got all the column as text. for examle: 30/04/2014 shows as 41759. i tried re-formatting the cells and the column, but nothing helps, it stills...