Posted to microsoft.public.excel.misc

MichaelR

external usenet poster

Posts: 38

Date Formatting

Hi,

I'm trying to format a system generated file to be more user friendly. The
file outputs dates like this: 20080714. Is there any way that I can change
the format to 07/14/2008 through a macro or a worksheet formula? I tried to
format the cells as dates but it didn't work.

Any ideas would be greatly appreciated.

Thanks!
Michael

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 Formatting (*)	jbc	Excel Discussion (Misc queries)	2	October 9th 06 06:09 PM
Formatting Date	newguy	Excel Discussion (Misc queries)	4	September 18th 06 01:49 PM
date formatting	BernieH	Excel Discussion (Misc queries)	2	May 30th 05 03:33 PM
formatting date	Torrance Pollard	Excel Worksheet Functions	2	April 2nd 05 05:03 PM

All times are GMT +1. The time now is 09:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us