Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I export a set of data from SQL and have a column showing dates. An
example of this format is 5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this column to show just the date without the time element. but excel wont recognise this as a date. How can I work around this? Thanks for your kind advice. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
Date Wont Change in Excel??! | Excel Worksheet Functions | |||
Formt of Linked cell | Links and Linking in Excel | |||
conditional formula to recognize day of the week from date | Excel Discussion (Misc queries) | |||
Formt column | Excel Discussion (Misc queries) |