software

I've looked all over the place and can't find this anywhere. We just want to
type numbers such as 020406 and have Excel format as 02/04/06. Can anyone
help please?

Chip Pearson has some code that may help you:
cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

Teri wrote:
gt;
gt; I've looked all over the place and can't find this anywhere. We just want to
gt; type numbers such as 020406 and have Excel format as 02/04/06. Can anyone
gt; help please?

--

Dave Peterson

Thanks for your reply, Dave. When I copy and paste the formula at Chip's
site, it doesn't work.

quot;Dave Petersonquot; wrote:

gt; Chip Pearson has some code that may help you:
gt; cpearson.com/excel/DateTimeEntry.htm
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; Teri wrote:
gt; gt;
gt; gt; I've looked all over the place and can't find this anywhere. We just want to
gt; gt; type numbers such as 020406 and have Excel format as 02/04/06. Can anyone
gt; gt; help please?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Those are macros.

You'll want to read David McRitchie's intro.

Teri wrote:
gt;
gt; Thanks for your reply, Dave. When I copy and paste the formula at Chip's
gt; site, it doesn't work.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Chip Pearson has some code that may help you:
gt; gt; cpearson.com/excel/DateTimeEntry.htm
gt; gt;
gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt;
gt; gt; Teri wrote:
gt; gt; gt;
gt; gt; gt; I've looked all over the place and can't find this anywhere. We just want to
gt; gt; gt; type numbers such as 020406 and have Excel format as 02/04/06. Can anyone
gt; gt; gt; help please?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson