date default error after 1999

[Mollyb]

Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
formats. All other date formats work correctly. Is a setting off
somewhere?

[Fred Smith]

Date formats work correctly in the 21st century. That's not your problem. I
suspect you have the wrong underlying date. Display your date in full using
mm/dd/yyyy, so you can make sure it's correct.

--
Regards,
Fred


"Mollyb" <[email protected]> wrote in message
news:[email protected]...
> Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> formats. All other date formats work correctly. Is a setting off
> somewhere?

[Mollyb]

Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
combinations work perfectly. I tried each format with dates pre and post
1999 and todays date. I've gone to one of the other staff's computers (each
has it's own software rather than using a network version), and still get
exactly the same problem. My nurse practitioner really does want the short
version because patients frequently can't remember specific dates. Any
other ideas or suggestions?

Molly

"Fred Smith" wrote:

> Date formats work correctly in the 21st century. That's not your problem. I
> suspect you have the wrong underlying date. Display your date in full using
> mm/dd/yyyy, so you can make sure it's correct.
>
> --
> Regards,
> Fred
>
>
> "Mollyb" <[email protected]> wrote in message
> news:[email protected]...
> > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > formats. All other date formats work correctly. Is a setting off
> > somewhere?
>
>
>

[Dave Peterson]

Select one of the cells that don't work correctly.

What do you see in the formulabar?

If you put this into an empty cell:
=isnumber(x99)
(change x99 to the cell that holds the problem date)
what do you get back?



Mollyb wrote:
>
> Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
> combinations work perfectly. I tried each format with dates pre and post
> 1999 and todays date. I've gone to one of the other staff's computers (each
> has it's own software rather than using a network version), and still get
> exactly the same problem. My nurse practitioner really does want the short
> version because patients frequently can't remember specific dates. Any
> other ideas or suggestions?
>
> Molly
>
> "Fred Smith" wrote:
>
> > Date formats work correctly in the 21st century. That's not your problem. I
> > suspect you have the wrong underlying date. Display your date in full using
> > mm/dd/yyyy, so you can make sure it's correct.
> >
> > --
> > Regards,
> > Fred
> >
> >
> > "Mollyb" <[email protected]> wrote in message
> > news:[email protected]...
> > > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > > formats. All other date formats work correctly. Is a setting off
> > > somewhere?
> >
> >
> >

--

Dave Peterson

[Mollyb]

Dave,

The problem isn't cell specific - seems to be unique to those three formats.
I took some cells, formatted the date in various ways, including the three
that I'm having problems with, entered the =isnumber(x99) and each time the
answer returned was FALSE. What is that telling me?

Thanks.

Molly

"Dave Peterson" wrote:

> Select one of the cells that don't work correctly.
>
> What do you see in the formulabar?
>
> If you put this into an empty cell:
> =isnumber(x99)
> (change x99 to the cell that holds the problem date)
> what do you get back?
>
>
>
> Mollyb wrote:
> >
> > Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
> > combinations work perfectly. I tried each format with dates pre and post
> > 1999 and todays date. I've gone to one of the other staff's computers (each
> > has it's own software rather than using a network version), and still get
> > exactly the same problem. My nurse practitioner really does want the short
> > version because patients frequently can't remember specific dates. Any
> > other ideas or suggestions?
> >
> > Molly
> >
> > "Fred Smith" wrote:
> >
> > > Date formats work correctly in the 21st century. That's not your problem. I
> > > suspect you have the wrong underlying date. Display your date in full using
> > > mm/dd/yyyy, so you can make sure it's correct.
> > >
> > > --
> > > Regards,
> > > Fred
> > >
> > >
> > > "Mollyb" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > > > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > > > formats. All other date formats work correctly. Is a setting off
> > > > somewhere?
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

That's telling you that the value in that cell isn't a date. It's text
masquerading as a date.

And since numberformats don't affect text, that's the problem.

Try formatting the cell as general and typing in the date one more time.

Then you should be able to format it as a date.

Mollyb wrote:
>
> Dave,
>
> The problem isn't cell specific - seems to be unique to those three formats.
> I took some cells, formatted the date in various ways, including the three
> that I'm having problems with, entered the =isnumber(x99) and each time the
> answer returned was FALSE. What is that telling me?
>
> Thanks.
>
> Molly
>
> "Dave Peterson" wrote:
>
> > Select one of the cells that don't work correctly.
> >
> > What do you see in the formulabar?
> >
> > If you put this into an empty cell:
> > =isnumber(x99)
> > (change x99 to the cell that holds the problem date)
> > what do you get back?
> >
> >
> >
> > Mollyb wrote:
> > >
> > > Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
> > > combinations work perfectly. I tried each format with dates pre and post
> > > 1999 and todays date. I've gone to one of the other staff's computers (each
> > > has it's own software rather than using a network version), and still get
> > > exactly the same problem. My nurse practitioner really does want the short
> > > version because patients frequently can't remember specific dates. Any
> > > other ideas or suggestions?
> > >
> > > Molly
> > >
> > > "Fred Smith" wrote:
> > >
> > > > Date formats work correctly in the 21st century. That's not your problem. I
> > > > suspect you have the wrong underlying date. Display your date in full using
> > > > mm/dd/yyyy, so you can make sure it's correct.
> > > >
> > > > --
> > > > Regards,
> > > > Fred
> > > >
> > > >
> > > > "Mollyb" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > > > > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > > > > formats. All other date formats work correctly. Is a setting off
> > > > > somewhere?
> > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[Mollyb]

You're a genius! It works! Thanks so much.

Molly


"Dave Peterson" wrote:

> That's telling you that the value in that cell isn't a date. It's text
> masquerading as a date.
>
> And since numberformats don't affect text, that's the problem.
>
> Try formatting the cell as general and typing in the date one more time.
>
> Then you should be able to format it as a date.
>
> Mollyb wrote:
> >
> > Dave,
> >
> > The problem isn't cell specific - seems to be unique to those three formats.
> > I took some cells, formatted the date in various ways, including the three
> > that I'm having problems with, entered the =isnumber(x99) and each time the
> > answer returned was FALSE. What is that telling me?
> >
> > Thanks.
> >
> > Molly
> >
> > "Dave Peterson" wrote:
> >
> > > Select one of the cells that don't work correctly.
> > >
> > > What do you see in the formulabar?
> > >
> > > If you put this into an empty cell:
> > > =isnumber(x99)
> > > (change x99 to the cell that holds the problem date)
> > > what do you get back?
> > >
> > >
> > >
> > > Mollyb wrote:
> > > >
> > > > Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
> > > > combinations work perfectly. I tried each format with dates pre and post
> > > > 1999 and todays date. I've gone to one of the other staff's computers (each
> > > > has it's own software rather than using a network version), and still get
> > > > exactly the same problem. My nurse practitioner really does want the short
> > > > version because patients frequently can't remember specific dates. Any
> > > > other ideas or suggestions?
> > > >
> > > > Molly
> > > >
> > > > "Fred Smith" wrote:
> > > >
> > > > > Date formats work correctly in the 21st century. That's not your problem. I
> > > > > suspect you have the wrong underlying date. Display your date in full using
> > > > > mm/dd/yyyy, so you can make sure it's correct.
> > > > >
> > > > > --
> > > > > Regards,
> > > > > Fred
> > > > >
> > > > >
> > > > > "Mollyb" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > > > > > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > > > > > formats. All other date formats work correctly. Is a setting off
> > > > > > somewhere?
> > > > >
> > > > >
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Glad you got it working!

Mollyb wrote:
>
> You're a genius! It works! Thanks so much.
>
> Molly
>
> "Dave Peterson" wrote:
>
> > That's telling you that the value in that cell isn't a date. It's text
> > masquerading as a date.
> >
> > And since numberformats don't affect text, that's the problem.
> >
> > Try formatting the cell as general and typing in the date one more time.
> >
> > Then you should be able to format it as a date.
> >
> > Mollyb wrote:
> > >
> > > Dave,
> > >
> > > The problem isn't cell specific - seems to be unique to those three formats.
> > > I took some cells, formatted the date in various ways, including the three
> > > that I'm having problems with, entered the =isnumber(x99) and each time the
> > > answer returned was FALSE. What is that telling me?
> > >
> > > Thanks.
> > >
> > > Molly
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > Select one of the cells that don't work correctly.
> > > >
> > > > What do you see in the formulabar?
> > > >
> > > > If you put this into an empty cell:
> > > > =isnumber(x99)
> > > > (change x99 to the cell that holds the problem date)
> > > > what do you get back?
> > > >
> > > >
> > > >
> > > > Mollyb wrote:
> > > > >
> > > > > Thanks, Fred. mm/dd/yyy and all formats except the three short month/year
> > > > > combinations work perfectly. I tried each format with dates pre and post
> > > > > 1999 and todays date. I've gone to one of the other staff's computers (each
> > > > > has it's own software rather than using a network version), and still get
> > > > > exactly the same problem. My nurse practitioner really does want the short
> > > > > version because patients frequently can't remember specific dates. Any
> > > > > other ideas or suggestions?
> > > > >
> > > > > Molly
> > > > >
> > > > > "Fred Smith" wrote:
> > > > >
> > > > > > Date formats work correctly in the 21st century. That's not your problem. I
> > > > > > suspect you have the wrong underlying date. Display your date in full using
> > > > > > mm/dd/yyyy, so you can make sure it's correct.
> > > > > >
> > > > > > --
> > > > > > Regards,
> > > > > > Fred
> > > > > >
> > > > > >
> > > > > > "Mollyb" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
> > > > > > > month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
> > > > > > > formats. All other date formats work correctly. Is a setting off
> > > > > > > somewhere?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson