Posted to microsoft.public.excel.misc

Stephanie

external usenet poster

Posts: 93

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formatting for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Date and Formatting	Ray	Excel Worksheet Functions	5	December 23rd 09 05:06 AM
Date formatting	AJ	Excel Discussion (Misc queries)	1	May 6th 09 06:01 PM
Date formatting	Sandy	Excel Worksheet Functions	2	August 1st 07 09:32 PM
XML date formatting	Richard Roche	Excel Worksheet Functions	0	December 6th 05 06:49 PM

All times are GMT +1. The time now is 11:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us