Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Imported Date Formats
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 date 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.... -- Craig Lloyd ------------------------------------------------------------------------ Craig Lloyd's Profile: http://www.excelforum.com/member.php...o&userid=29769 View this thread: http://www.excelforum.com/showthread...hreadid=494841 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell contents so that Excel recognises it as a date | Excel Discussion (Misc queries) | |||
Changing date format in a footer | Excel Discussion (Misc queries) | |||
Date Formats | Excel Discussion (Misc queries) | |||
troubleshooting date formats | Excel Discussion (Misc queries) | |||
Excel date formats | Excel Discussion (Misc queries) |