Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported Data Date Format Problem
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.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported Data Date Format Problem
"Craig" wrote in message
... 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.... Dates are stored as integers and time as a fraction of a day. So, Excel stores the date/time you quote as 38691.0208217593 where 38691 represents the date and 0.0208217593 represents the time. To get just the date, if the time/date is in A1 you can use the formula =INT(A1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data into standard military time format | Excel Discussion (Misc queries) | |||
How do I stop a general format from being autoformatted to date | New Users to Excel | |||
date format problem | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |