Re: Date Format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "C. Bailey" <reply@xxxxxxxxxxxxx>
Date: Sat, 02 Apr 2005 22:41:13 GMT

Thank you for the numerous responses. None of the answers given were
entirely correct, but they did direct me to look in the right place.

The problem in my case was that I had input my location in the regional
settings as English Canada. When I switched to English US, my problems were
resolved.

Chris

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:8pkt41hlkm2n30vfhhhfdsdoe954j8pap9@xxxxxxxxxx
> It is in Windows.
>
> Open Control Panel and Regional and Language Options>Regional
> Options>Customize>Date.
>
> Set the limits for years under Calendar.
>
>
> Gord Dibben Excel MVP

.

References:
- Date Format
  - From: C. Bailey
- Re: Date Format
  - From: Gord Dibben

Prev by Date: Finding last record in month for each of several types of record.
Next by Date: Re: Help with Totalling Groups Please
Previous by thread: Re: Date Format
Next by thread: How to rename autoshapes on a work***
Index(es):
- Date
- Thread