Community response. No action needed.
-Ivan
--------------------
| Message-ID: <
[email protected]>
| Date: Tue, 14 Oct 2003 19:13:35 -0500
| From: Dave Peterson <
[email protected]>
| Reply-To: (e-mail address removed)
| X-Mailer: Mozilla 4.78 [en] (Win98; U)
| X-Accept-Language: en
| MIME-Version: 1.0
| Subject: Re: Office '97 and XP date problems
| References: <
[email protected]>
| 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!TK2MSFTNGP11.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
| (e-mail address removed)
|
)