[access-uk] Re: Excel help please
- From: catherineturner2007@xxxxxxxxxxxxxx
- To: access-uk@xxxxxxxxxxxxx
- Date: Tue, 19 Aug 2008 18:35:15 +0100
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
Other related posts:
