Thread: Date formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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