Office '97 and XP date problems

I am trying to configure my worksheet to where I can
simply type 6 digits, such as today's date of 101403, and
the worksheet will convert it to 10/14/03. When I don't
type the forward slashes between the numbers it displays
08/17/77. Is there any way to fix this so that I can
punch in 6 digits and it will convert it to the correct
format ?

You'll need some code. But Chip Pearson has it ready for you:

http://www.cpearson.com/excel/DateTimeEntry.htm

Justin wrote:

I am trying to configure my worksheet to where I can
simply type 6 digits, such as today's date of 101403, and
the worksheet will convert it to 10/14/03. When I don't
type the forward slashes between the numbers it displays
08/17/77. Is there any way to fix this so that I can
punch in 6 digits and it will convert it to the correct
format ?

--

Dave Peterson

Community response. No action needed.
-Ivan

--------------------
| Message-ID:
| Date: Tue, 14 Oct 2003 19:13:35 -0500
| From: Dave Peterson
| Reply-To:
| X-Mailer: Mozilla 4.78 [en] (Win98; U)
| X-Accept-Language: en
| MIME-Version: 1.0
| Subject: Office '97 and XP date problems
| References:
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.excel.setup
| NNTP-Posting-Host: 1Cust77.tnt2.belvidere.il.da.uu.net 67.200.45.77
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.setup:17223
| X-Tomcat-NG: microsoft.public.excel.setup
|
| You'll need some code. But Chip Pearson has it ready for you:
|
| http://www.cpearson.com/excel/DateTimeEntry.htm
|
| Justin wrote:
|
| I am trying to configure my worksheet to where I can
| simply type 6 digits, such as today's date of 101403, and
| the worksheet will convert it to 10/14/03. When I don't
| type the forward slashes between the numbers it displays
| 08/17/77. Is there any way to fix this so that I can
| punch in 6 digits and it will convert it to the correct
| format ?
|
| --
|
| Dave Peterson
|
|

er, what's this mean?

Ivan Sheng wrote:

Community response. No action needed.
-Ivan


--

Dave Peterson

Hi Dave!

This is an internal note that indicates that someone from the community
addressed this question. Unfortunately, it was not marked internal. Stuff
happens. )

Best Regards,

Marie McFadden, MCSE NT4/2000, MCSA
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.