[access-uk] Re: Help with MS Excel
- From: "George Bell" <george@xxxxxxxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sat, 19 Feb 2005 23:25:26 -0000
Sorry, Andrew. I should have read the Subject. You mean
Excel?
From Excel's Help files.
Change the default date format
By default, as you enter dates in a workbook, the dates are
formatted to display two-digit years.
Change the way two-digit years are interpreted
Caution This procedure changes the way two-digit years are
interpreted for all the Microsoft Windows programs that you
have installed.
On the Windows Start menu, point to Settings, and then click
Control Panel.
Double click the Regional Settings or Regional Options icon.
In the When a two-digit year is entered, interpret as a year
between box, change the upper limit for the century.
As you change the upper-limit year, the lower-limit year
automatically changes.
Change the default date format to display four-digit years
When you change the default date format to a different
format by using this procedure, the display of dates that
were previously entered in your workbook will change to the
new format as long as the dates haven't been formatted by
using the Cells command (Format menu).
On the Microsoft Windows Start menu, point to Settings, and
then click Control Panel.
Double click the Regional Settings or Regional Options icon.
In the Short date format list, click a format that uses four
digits for the year ("yyyy").
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Andrew Shipp
Sent: 19 February 2005 22:30
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Help with MS Excel
office XP pro 2003,
Regards
Andrew Shipp
Located Northampton
Northamptonshire, England
Contact details
andyshipp54@xxxxxxxxxxx
skype andyshipp50
Echolink m0ceg node 220334
Home phone+44,0,1604 517007
mobile 07773457805
I am also the moderator for the blind-gardening group to
subscribe send a blank email to
blind-gardening-subscribe@xxxxxxxxxxxxxxx
----- Original Message -----
From: "George Bell" <george@xxxxxxxxxxxxxxxxxxx>
To: <access-uk@xxxxxxxxxxxxx>
Sent: Saturday, February 19, 2005 5:00 PM
Subject: [access-uk] Re: Help with MS Excel
> Which Office program, Andrew?
>
> George.
>
> -----Original Message-----
> From: access-uk@xxxxxxxxxxxxx
> [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Andrew Shipp
> Sent: 19 February 2005 16:22
> To: access-uk
> Subject: [access-uk] Help with MS Excel
>
> Hello Please can someone help me out here, I am using MS
> office XP pro 2003, and I have the following problem,
when
> entering a date using the keystroke CTRL semi colon I
keep
> on getting the DD/MM/YY appearing also is there away to
> stop this please, I also get the similar happening in the
> time like HH:MM, I would be very grateful if someone
could
> help me sort these silly little problems out.
> Regards
> Andrew Shipp
> Located Northampton
> Northamptonshire, England
> Contact details
> andyshipp54@xxxxxxxxxxx
> skype andyshipp50
> Echolink m0ceg node 220334
> Home phone+44,0,1604 517007
> mobile 07773457805
> I am also the moderator for the blind-gardening group to
> subscribe send a blank email to
> blind-gardening-subscribe@xxxxxxxxxxxxxxx
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.1.0 - Release Date:
> 18/02/2005
>
> ** To leave the list, click on the immediately-following
> link:-
> **
>
[mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** access-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on
> the
> ** immediately-following link:-
> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
>
>
>
>
> This Message has been scanned for viruses by McAfee
Groupshield.
> ** To leave the list, click on the immediately-following
link:-
> **
[mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** access-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on
the
> ** immediately-following link:-
> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.1.0 - Release Date:
18/02/2005
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date:
18/02/2005
** To leave the list, click on the immediately-following
link:-
**
[mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on
the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
This Message has been scanned for viruses by McAfee Groupshield.
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts: