[access-uk] Re: Excel help please [Scanned]
- From: <naomijenkins@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 19 Aug 2008 19:13:49 +0100
Hi Catherine
I'm not sure if this is what you want.
If the cell format is set to General and you want Excel to display a
fraction as a decimal you can put = in front of your fraction. For
example =3/4 will be displayed as 0.75.
There is another way: If the cell format is set to number with 2 decimal
places the same thing will happen 3/4 will be displayed as 0.75
HTH
Naomi
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf
Of catherineturner2007@xxxxxxxxxxxxxx
Sent: 19 August 2008 18:35
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel help please [Scanned]
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
This email and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed.
Any view or opinions presented are solely those of the author and do not
necessarily represent those of Exeter College.
Exeter College... Keeping you informed
We're improving our college telephone system during Thursday 22nd and Friday
23rd May. We don't anticipate any disruption to normal service, but if you do
have difficulties getting through to us please retry the number or
alternatively, email info@xxxxxxxxxxxxxx with details of your enquiry. Thank
you for your patience during this process.
If you have received this email in error, or if you believe this email is
unsolicited and wish to be removed from any future mailings, please contact our
IT Support
Desk immediately on 01392 205497 or email itsupport@xxxxxxxxxxxxxxx
** 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:
