Thread: Date formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephanie Stephanie is offline
external usenet poster
 
Posts: 93
Default 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.