Posted to microsoft.public.excel.misc

external usenet poster

Posts: 45

Date Display

How can I configure a cell so that I can enter 11152007 as a date and have it
display as 11/15/2007?

Thanks,

patty

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
Formula to Display Date n-Workdays from a Certain Date	BHadds	Excel Discussion (Misc queries)	4	June 13th 07 09:49 PM
display date	eesh	New Users to Excel	2	February 26th 07 12:26 PM
date display	pamwp	Excel Discussion (Misc queries)	2	February 5th 07 03:20 PM
X axis date - display beyond latest date.	Dave F.	Charts and Charting in Excel	1	January 3rd 07 03:17 AM
Date display	new2XL	Excel Discussion (Misc queries)	1	June 14th 06 04:33 PM

All times are GMT +1. The time now is 05:33 AM.

About Us

"It's about Microsoft Excel"