Posted to microsoft.public.excel.misc

Cyrus

Posts: n/a

date entry without typing dashes

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

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
Auto date entry for status change	Alec H	Excel Discussion (Misc queries)	2	February 7th 06 12:41 AM
back date calculation?	[email protected]	Excel Worksheet Functions	1	January 15th 06 05:10 PM
A DROP DOWN CALENDAR FOR DATE ENTRY	GURU	Excel Discussion (Misc queries)	1	September 24th 05 06:54 PM
How do I set up Auotomatic date and time entry in an adjacent cell	Geoffrey	Excel Discussion (Misc queries)	2	September 1st 05 01:03 PM
How do I calculate if a date is in a certain time frame?	Pe66les	Excel Worksheet Functions	19	August 27th 05 11:07 PM

All times are GMT +1. The time now is 07:26 AM.

About Us

"It's about Microsoft Excel"