Re: Input Masks in Excel?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you have got a lot, take a look at
http://www.xldynamic.com/source/xld.QDEDownload.html

--
HTH

Bob Phillips

"PattiP" <PattiP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:49B5CDEE-2C90-4222-9159-38DD87D9B947@xxxxxxxxxxxxxxxx
> Is there a way to convert the entry, i.e. 032405, and have it show up in
> another cell in date format? Some kind of VB code?
>
> "Bob Phillips" wrote:
>
> > No, it's all manual.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "PattiP" <PattiP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:DE3550BA-00FB-4052-9246-74AD1917CBF9@xxxxxxxxxxxxxxxx
> > > Does Excel have input masks, similar to Access? I would like the user
to
> > > enter a date field but not have to insert the "/" marks. Example:
enter
> > > 032405 and it would show up as 03/24/05. Thanks!
> > > --
> > > Patti
> >
> >
> >


.

Relevant Pages

  • Re: Adapting some code
    ... > Bob Phillips Wrote: ... >> Dim entry As Range, foundentry As Range, firstaddress As String ... >> HTH ...
    (microsoft.public.excel.programming)
  • Re: Conditional formating, values.
    ... The trick is to ensure that that is the first condition, ... > HTH ... > Bob Phillips ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Totaling Months
    ... HTH ... Bob Phillips ... > I have 3 columns in my worksheet, column F Date Due, column G is Date ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: limiting combo box entry
    ... "Bob Phillips" wrote: ... > HTH ... >> List Boxes don't offer the same usability options as combo boxes. ... >> then great but I can't believe there's no way to limit combo box entry. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: excel sorting task
    ... HTH ... Bob Phillips ... > I have the following data in a worksheet ... Prev by Date: ...
    (microsoft.public.excel.misc)