[access-uk] Re: Excel help please
- From: "David W Wood" <g3yxx@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 19 Aug 2008 18:49:26 +0100
Catherine:
Why not make it simpler.
In a1 put 10
In a2 put 1
In a3 the formula =1+A2/A1
No doubt guru Steve will have another idea!!!!!!
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
catherineturner2007@xxxxxxxxxxxxxx
Sent: Tuesday, August 19, 2008 6:35 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel help please
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
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.4/1617 - Release Date: 17/08/2008
12:58
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.4/1617 - Release Date: 17/08/2008
12:58
** 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:
