C
Craig Lloyd
Hi all,
I have set up an Excel Spreadsheet that imports data from a sql
database using the 'external data' function.
The problem is that the dates being retrieved from the db are in the
format 5/12/2005 12:29:59 AM
I have set excel to display the dates as short dates, ie 05/12/2005
without the time but whilst the date displays correctly if the cell is
selected the original date format is still displayed.
This is preventing me from creating rules and using counting formulas
etc
Can anyone help???? Please....
I have set up an Excel Spreadsheet that imports data from a sql
database using the 'external data' function.
The problem is that the dates being retrieved from the db are in the
format 5/12/2005 12:29:59 AM
I have set excel to display the dates as short dates, ie 05/12/2005
without the time but whilst the date displays correctly if the cell is
selected the original date format is still displayed.
This is preventing me from creating rules and using counting formulas
etc
Can anyone help???? Please....