Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
Hi- I have a system that downloads into Excel a timestamp in this format:
Thursday, December 31, 2009 8:00:59 AM however, this is not a date field but rather a general field so that I can't use formatting to get to December 31, 2009 I'd appreciate suggestions for stripping it down. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
Hi Stephanie
With your value in cell A1, then =MID(A1,FIND(",",A1)+2,FIND("^",SUBSTITUTE(A1,",", "^",2))+6-(FIND(",",A1)+2)) -- Regards Roger Govier "Stephanie" wrote in message ... Hi- I have a system that downloads into Excel a timestamp in this format: Thursday, December 31, 2009 8:00:59 AM however, this is not a date field but rather a general field so that I can't use formatting to get to December 31, 2009 I'd appreciate suggestions for stripping it down. Thanks. __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Date and Formatting | Excel Worksheet Functions | |||
Date formatting | Excel Discussion (Misc queries) | |||
Date formatting | Excel Worksheet Functions | |||
XML date formatting | Excel Worksheet Functions |