[access-uk] Re: Excel question
- From: "George Bell" <george@xxxxxxxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sun, 12 Jun 2005 14:41:17 +0100
Hi Catherine,
The cell in question is formatted as a Date.
If you wish to change the appearance, (which will not
actually change the figures) highlight the cell, or cells,
that contain the date, and from the format menu, select
Cells. The dialog that comes up will them allow you to
select a Format type, such as General, Date, Number, etc.,
and you will also find in the same dialog a format for the
selected Type.
George.
> -----Original Message-----
> From: access-uk@xxxxxxxxxxxxx
> [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Catherine
Turner
> Sent: 12 June 2005 14:08
> To: Access-UK
> Subject: [access-uk] Excel question
>
> Hi,
>
> In an excel sheet someone's given me one of the cells has
> Dec-04 written it.
> I wanted to edit it so I pressed f2, but then it says
> 01/12/04. How come it says Dec-04 when just moving
through
> the columns but when I press f2 it says 01/12/04?
>
> Catherine
>
> ** 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
>
>
** 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:
