[access-uk] Re: Excel help please

  • From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Wed, 20 Aug 2008 13:50:05 +0100

Catherine,

I think Carol meant Control + 1. Tab into the Category list and
DownArrow to Fractions, then Tab again into a list of the possible
formats you can choose from.

Steve

-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf
Of catherineturner2007@xxxxxxxxxxxxxx
Sent: 20 August 2008 13:10
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel help please

Hi Carol,

When I press Control f1 nothing seems to happen...

Catherine

On 8/20/08, Carol Pearson <carol.pearson29@xxxxxxxxxxxxxx> wrote:
> Catherine,
>
> Select the column you want in the fraction format and type CTRL+F1 and
> you'll find a fraction and decimal option there.
>
> If you can't get it working from this description, I may be able to
help
> further, given a bit of time and some playing.
>
> HTH:
>
> --
> Carol
> carol.pearson29@xxxxxxxxxxxxxx
>
> On Tuesday, August 19, 2008 6:35 PM (UK time),
> catherineturner2007@xxxxxxxxxxxxxx at
catherineturner2007@xxxxxxxxxxxxxx
> said:
>
>> Hi,
>>
>> Thanks - this kind of helps but not really as I've realised I don't
>> want Excel to treat 10/1 as a piece of text or date, but rather as a
>> fraction.
>>
>> Basically what I'm wanting to do is make it convert odds expressed as
>> fractions into odds expressed as decimals.  So if I type 10/1 in cell
>> a1, I then want to do a formula in A2 which is a1 +1.  Whatever the
>> fractions are I put in row 1, I want it to do a sum on them and add
1.
>>
>> I've also now realised that even if I just type 10 it converts it
>> into 10 Jan...
>>
>> Catherine
>>
>> On 8/15/08, Griffiths, Steve <Steve.Griffiths@xxxxxxxxxxx> wrote:
>>> Or, put an apostrophe before the number and Excel will treat it as
>>> text. So '1/3 will appear as 1/3 in the cell.
>>>
>>> Steve
>>>
>>> -----Original Message-----
>>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On
>>> Behalf Of David W Wood
>>> Sent: 14 August 2008 15:59
>>> To: access-uk@xxxxxxxxxxxxx
>>> Subject: [access-uk] Re: Excel help please
>>>
>>> Highlight the cell or range of cells in question,
>>> Ctrl+1 (format cells)
>>> Tab (you will probably hear 'date' spoken).
>>> Press t until you hear 'text' spoken.
>>> Press 'enter'
>>> Job done
>>>
>>>
>>>
>>> David W Wood
>>>
>>> GUILDFORD PHYSIOTHERAPY AND SPORTS CLINIC
>>> MATTHEWS HOUSE
>>> 85 EPSOM ROAD
>>> GUILDFORD
>>> SURREY GU1 3PA
>>>
>>> T: 01483 575876 (APPOINTMENTS)
>>>          302691 (ALL OTHER INQUIRIES)
>>>
>>> E: reception@xxxxxxxxxxxxxxxxxxx
>>> W: http://tinyurl.com/5wptcp
>>>
>>> ____________________
>>> DISCLAIMER
>>> The information contained in this e-mail is strictly confidential
>>> and is intended solely for the individual/s to whom it is addressed.
>>> If you are not
>>> the intended recipient or have received this e-mail in error please
>>> delete
>>> it immediately.  Any disclosure including but not withstanding
>>> reading copying or distribution of all or part of the information
>>> contained herein
>>> is strictly prohibited and may be unlawful.  Although this email and
>>> any attachments are believed to be free of any virus or any other
>>> defect which
>>> might affect any computer or system on which they are received
and/or
>>> opened
>>> it is the responsibility of the recipient to ensure that they are
>>> virus free
>>> and no responsibility is accepted by The Guildford Physiotherapy and
>>> Sports
>>> Clinic for any loss or damage arising in any way from receipt or use
>>> thereof.   Any opinions or advice contained in this email are not
>>> necessarily those of The Guildford Physiotherapy and Sports Clinic
or
>>> any
>>> individual or individuals working or acting on its behalf.
>>>
>>> All prices shown are in pounds sterling and exclude VAT, Delivery
and
>>> Expense charges unless otherwise stated.
>>> -----Original Message-----
>>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On
>>> Behalf Of
>>> Catherine Turner
>>> Sent: Thursday, August 14, 2008 3:46 PM
>>> To: Access-UK
>>> Subject: [access-uk] Excel help please
>>>
>>> Hi,
>>>
>>> How can I stop Excel from converting 1/3 (one slash three) into a
>>> date automatically?  I just want it to stay as 1/3.  I suppose this
>>> is in auto format somewhere but I can't figure out where...
>>>
>>> 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
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG.
>>> Version: 7.5.524 / Virus Database: 270.6.3/1610 - Release Date:
>>> 13/08/2008
>>> 16:14
>>>
>>>
>>> No virus found in this outgoing message.
>>> Checked by AVG.
>>> Version: 7.5.524 / Virus Database: 270.6.3/1610 - Release Date:
>>> 13/08/2008
>>> 16:14
>>>
>>>
>>> ** 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
>>>
>>>
>>>
>>> --
>>> DISCLAIMER:
>>>
>>> NOTICE: The information contained in this email and any attachments
>>> is confidential and may be privileged.  If you are not the intended
>>> recipient you should not use, disclose, distribute or copy any of
the
>>> content of it or of any attachment; you are requested to notify the
>>> sender immediately of your receipt of the email and then to delete
it
>>> and any attachments from your system.
>>>
>>> RNIB endeavours to ensure that emails and any attachments generated
>>> by its staff are free from viruses or other contaminants.  However,
>>> it cannot accept any responsibility for any  such which are
>>> transmitted. We therefore recommend you scan all attachments.
>>>
>>> Please note that the statements and views expressed in this email
and
>>> any attachments are those of the author and do not necessarily
>>> represent those of RNIB.
>>>
>>> RNIB Registered Charity Number: 226227
>>>
>>> Website: http://www.rnib.org.uk
>>>
>>>
>>>
>>> This message has been scanned for viruses by BlackSpider MailControl
>>> - www.blackspider.com
>>> ** 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
>
> ** 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



 
** 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: