Cross Linking Date Cells
Hi I don't know if this is a bug or not but, I have a summary sheet which has a column set as Text/Number I link into it from a number of sheets, the links can be contact names, descriptions, addresses etc, I have two cells in the column I want to populate with a start and an end date taken from a project plan sheet. When I use the "link from the cell in other sheet" option, I get the date across but it is in the format MM/DD/YY and not DD/MM/YY. Any ideas? I can't set the column to Date as there are text entries as well. My date format is set correctly in personal settings and I am the creator/owner of both sheets.
Kind regards.. Ben.